i wanna show the name of users whose birthday is coming near by capturing their month day and year.... from the table...
how's that possible???
how to show...
Moderator: General Moderators
Code: Select all
$BirthDaysRes=@mysql_query("SELECT FullName,DOB FROM Classmates WHERE DATE_FORMAT(NOW(),'%d%m')=DATE_FORMAT(DOB,'%d%m')");Code: Select all
$BirthDaysRes=@mysql_query("SELECT FullName,DOB FROM Classmates WHERE DATE_FORMAT(NOW()+INTERVAL '".$GLOBALSї'TimeZone']."' HOUR_MINUTE,'%d%m')=DATE_FORMAT(DOB,'%d%m')");