PDA

View Full Version : Displaying Birthdays this Month


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>";
}

}

Tyran1
01-19-2013, 01:07 PM
its finish??