April 1st, 2010, 08:25 AM
It's a little sloppy, but:
$result1 = mysql_query("SELECT name, birthday FROM address WHERE STR_TO_DATE(CONCAT(DATE_FORMAT(NOW(), '%Y'), '-', DATE_FORMAT(birthday, '%m'), '-', DATE_FORMAT(birthday, '%d'))) BETWEEN CURDATE() AND CURDATE() + INTERVAL '1' MONTH");
HEY! YOU! Read the New User Guide and Forum Rules
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin
"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002
Think we're being rude? Maybe you asked a bad question
or you're a Help Vampire.
Trying to argue intelligently? Please read this.