I have a MySQL table containing a date column that is formatted as per MySQL
year-month-day
In creating a search form I developed a sql query to poulate a drop-down list containing all available months refomatted the way I want. See below:
SELECT DISTINCT DATE_FORMAT(sweventcalendar.eventdate, ‘%M’) AS fomattedeventmonth
FROM sweventcalendar
WHERE sweventcalendar.eventdate >= NOW()
However, when I pass the form variable, the selection from the drop-down list, which is called eventmonth, using the GET action, I get no results.
I know my querry works if I remove the date format from the code above.
My querry results is coded as follows:
SELECT sweventcalendar.eventtitle, sweventcalendar.eventdesc, sweventcalendar.eventurl1, sweventcalendar.eventurl2, sweventcalendar.eventurl3, DATE_FORMAT(sweventcalendar.eventdate, ‘%M %e, %Y’) AS fomattedeventdate
FROM sweventcalendar
WHERE eventdate = colname
/*colname is a date type with a default value of -1 and a run time value of $_GET[‘eventmonth’] */
Any help would be appreciated.
PS: is there something with the way I formated the date in setting up the form element that removes its value?
