MySQL and dates
Im trying to take events out of a MySQL database. I want them to be occuring on 'today' or any day after that. How can I do this?
Here is what I am working with...
What I have here pulls out all of the events that occur in 'this' month and 'this' year.
$DB_site->query("SELECT eventid, subject, event, eventdate, public, userid, time, place
WHERE eventdate LIKE '$year-$doublemonth-%' AND ((userid = '$bbuserinfo[userid]' AND public = 0) OR (public = 1))".$addsql);
Anyhelp would be greatly appreciated.
Duh.. how stupid. I just needed to get rid of 'LIKE' and use '>'.