In my current mysql db, i have 3 fields one for the day, one for the
month, and one for the year. I need to compare them to the current date.
This is the code I have so far, but it doesn't work.
$sql = "SELECT * FROM Movies WHERE CURDATE() > (DVD_Release_Year,
DVD_Release_Month, DVD_Release_Day) AS theDate LIMIT 0,7";
$result = @mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo $row['Movie_Title'] . '<br />';
}
Thanks
Justin Giboney
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
