Display this birthdays this month

[KatieG]

Hi

I am trying to display this months birthdays , I have this so far but displays no birthdays this month.. When I know there are,, can anyone help me...:)



$file = "connect.php";
if( file_exists( $file ) ) {
require $file;

$result = mysql_query("SELECT username,birthday FROM user WHERE MONTH(birthday) = MONTH(NOW())");
if( mysql_num_rows( $result ) != 0 ) {
while ( $row = mysql_fetch_array($result)) {


echo $row['username'];
echo "<br />";
echo $row['birthday'];
echo "<br />----------<br />";
}
}else{
echo "No Birthdays<br />This Month";
}

}else{
die("File $file does not exist");
}

[Boofo]

Have you tried this?

SELECT username,birthday FROM user WHERE MONTH(birthday) = MONTH(CURDATE())