Results 1 to 2 of 2
Thread: MySQL and dates
Jan 31, 2002, 19:07 #1
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...
$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.
Jan 31, 2002, 21:18 #2
Duh.. how stupid. I just needed to get rid of 'LIKE' and use '>'.