NineChime forum
Furry stuff, oekaki stuff, and other stuff.
You are not logged in.
- Index
- » Mods for Wacintaki/Wax
- » Birthdays for the month!
Post a reply
Topic review (newest first)
- Silverpaws006
- 09-27-2009 23:49:28
Umm, I used mysql_fetch_array 'cause I'm fetching more than one row,
come to think of it, I use that all the time xD
I'm not sure of it's difference with fetch_row and fetch_assoc really,
but I think I read an article saying fetch_array is faster(?) and kinda like a combination of both.
Well just in case, if the script doesn't work, people can change mysql_fetch_array to mysql_fetch_row.
- Waccoon
- 09-27-2009 21:43:08
One nit: you should use mysql_fetch_row() instead of mysql_fetch_array().
Code:
$result = mysql_query ("SELECT `get`, `some`, `names` FROM `op_table` ORDER BY `ID` DESC");
$row = mysql_fetch_array($result);
echo ($row['names']);
$row = mysql_fetch_row($result);
echo ($row[3]);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo ($row['names']);
$row = mysql_fetch_array($result, MYSQL_NUM);
echo ($row[3]);Using mysql_fetch_array() will work if your server has notices disabled, but fetching a row is preferred.
- rainbow
- 09-27-2009 00:59:47
Great idea! I might consider trying out this script on my oekaki board very soon to see if it works. 
- Silverpaws006
- 09-26-2009 23:24:59
Okay first, since this is my first post after registering... intro xD
I'm Silverpaws006/Char of URKaki.
uhh, I'm not really that good with PHP...
I made this script for our oekaki and just thought others might like it too :3
This displays the people with birthdays for the month
you can paste it on the notice:
P.S. I'm thinking up of more scripts when I have free time, so uhh,
to the admin: asking permission if I could post more soon?
Code:
<?php
//===========================================================================
// BIRTHDAYS START
// by Silverpaws006/Char of http://www.auropaws.com/
//===========================================================================
?>
<div style="padding:5px;width:400px;border:2px solid #ff6060;background:#ffffcc;color:#000000;">
<b>:: Birthdays this month ::</b>
<br/><br/>
<div style="text-align:left;">
<?php
$monthnow = date("m",time());
$query_dates = mysql_query("SELECT usrname, age FROM op_oekaki ORDER BY age ASC");
while($array = mysql_fetch_array($query_dates)) {
$date = $array[1];
$get_month = substr($date,5,2);
if($monthnow == $get_month) {
$to_timestamp = strtotime($date);
$to_date = date("M j",$to_timestamp);
$linkname = "<a onclick=\"openWindow('profile.php?user=$array[0]', 400, 600); return false\" href=\"profile.php?user=$array[0]\" style='color:#000000;'>$array[0]</a>
";
echo ($to_date . " - " . $linkname . "<br/>");
}
if(!$array) {
echo("No birthdays this month.");
}
}
?>
</div>
</div>
<?php
//===========================================================================
// BIRTHDAYS END
//===========================================================================
?>