how to show...
Posted: Fri Feb 18, 2005 10:53 am
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's that possible???
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
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')");