KatieG
05-18-2010, 05:46 PM
Hi
I want to display members with birthdays this month, I have this script working, and it displays the Members names in order of dates..
What I want todo is add the date where the red text is.... what do I add ????
Any help would really be appreciated..
thanks in advanced
$month = date("m");
$find = $db->query_read("SELECT userid,username,birthday FROM " . TABLE_PREFIX . "user WHERE birthday LIKE '$month-%'");
while ($user = $db->fetch_array($find))
{
$userid = $user['userid'];
$username = $user['username'];
$birthday = $user['birthday'];
$birthday = explode("-", $birthday);
$birthmonth = $birthday[0];
if ($birthmonth = $month)
{
echo "<p align=\"center\"><font color=\"red\"><b>$username - date<br></b></font></p>";
}
}
I want to display members with birthdays this month, I have this script working, and it displays the Members names in order of dates..
What I want todo is add the date where the red text is.... what do I add ????
Any help would really be appreciated..
thanks in advanced
$month = date("m");
$find = $db->query_read("SELECT userid,username,birthday FROM " . TABLE_PREFIX . "user WHERE birthday LIKE '$month-%'");
while ($user = $db->fetch_array($find))
{
$userid = $user['userid'];
$username = $user['username'];
$birthday = $user['birthday'];
$birthday = explode("-", $birthday);
$birthmonth = $birthday[0];
if ($birthmonth = $month)
{
echo "<p align=\"center\"><font color=\"red\"><b>$username - date<br></b></font></p>";
}
}