problem filtering dates
Posted: Wed Jul 11, 2007 8:36 am
I have a table which includes details of events but I only want to show those that are not in the past.
I am getting todays date in the format in which it is stored in my table.
my sql statement is:
The results display all the events in my table .
What have i got wrong with my syntax please or is there a better way to do this that a simple lass can understand
Any help appreciated
Nuts
I am getting todays date in the format in which it is stored in my table.
Code: Select all
$today = date("Y- m- d");Code: Select all
$sql = "SELECT * FROM rsu WHERE scheme LIKE '$scheme' AND webdate >= '$today' ORDER BY webdate ASC ";What have i got wrong with my syntax please or is there a better way to do this that a simple lass can understand
Any help appreciated
Nuts