I have a Calendar of Events table and I would like to select events with dates equal to or greater than today. When I use the following SELECT statement, it only retrieves events in the future (> NOW()):
$db->query("SELECT * FROM events WHERE event_date >= NOW()");
?>
How would I go about selecting all events that are either today or in the future?
Thank you
解决方案
You are looking for CURDATE():
$db->query("SELECT * FROM events WHERE event_date >= CURDATE()");
Or:
$db->query("SELECT * FROM events WHERE event_date >= CURRENT_DATE()");