compare months
Posted: Tue Sep 20, 2005 6:03 pm
Hi,
I am trying to compare a date/time column (sdate) to a variable "$requestmonth" which contains the month to be displayed.
This query doesn't work. No records are displayed.
How could I compare the months in sdate column to $requestmonth?
By the way it's in php.
I am trying to compare a date/time column (sdate) to a variable "$requestmonth" which contains the month to be displayed.
Code: Select all
"SELECT * FROM schedule WHERE sdate = " . $requestmonth . " ORDER BY sdate";How could I compare the months in sdate column to $requestmonth?
By the way it's in php.