Birthdays in Current Month

[KatieG]

I am trying to display the user birthdays this month

I have done the script below, although there is a birthday set this month
it shows " No Birthdays This Month "

Can anyone help please

<?php


include("connect.php");


$result = mysql_query("SELECT userid,username,birthday FROM user WHERE MONTH(birthday) = MONTH(NOW())");
if( mysql_num_rows( $result ) != 0 ) {
while ( $row = mysql_fetch_array($result))
{
$userid = $user['userid'];
$username = $user['username'];
$birthday = $user['birthday'];
$birthday = explode("-", $birthday);
$birthmonth = $birthday[0];
if ($birthmonth = $month)
{
echo "<a href='member.php?u=$userid'>$username</a>,&nbsp;";
}

}
}
else{
echo "No Birthdays This Month";
}
?>

[kh99]

Change your query to use
...WHERE MONTH(birthday_search) = MONTH(NOW())


(add the _search). I guess it's because the birthday field isn't one of the date formats that MySql will use or something like that. Anyway, I the rest of your code can still use the birthday column if you want.

[Tyran1]

works??

[BGObsession]

I have tried this code and it's not working - thoughts anyone?

[ozzy47]

If the user has, Hide Age and Date of Birth or Display Only Age set, they should not show up.