I'm trying to select records that have an ending event date/time after the current date/time. I have tried using a PHP variable $now=date("Y-m-d H:i:s");, CURDATE() as well as UNIX_TIMESTAMP in combination with strtotime("now");, but so far nothing is working.
SELECT * FROM `events` ORDER BY `eventStart` WHERE `eventEnd`>$now
Somehow I keep getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/portal/public_html/sandbox/<blocked>/calendar/calendar.php on line 63
The eventEnd field is a MySQL datetime field: "YYYY-MM-DD HH:mm:ss"