PDA

View Full Version : checking if date > today's date?


N!ck
02-12-2003, 03:42 PM
I want to make a query that will select calendar events that haven't gone by yet, but I don't know how to check with MySQL whether the date is greater than today's date. Shed some light? Thanks.

GSHelpBoy
02-12-2003, 06:14 PM
$sql = 'SELECT * FROM `calendar` WHERE `date` > UNIX_TIMESTAMP()';