date formatting within the query

[Anon]

I am requesting a date value stored in a mysql db stored in the default mysql date format. I request it as '%M' (just the month name) and then pass that thru the url to a action page.

I then need to set up a new query to select certain fields based on the same date field equaling my passed month string. So in my url let's say I pass $month=May

my query on the next page would be something like:

SELECT *
FROM database.tablename
WHERE datefield = $month

Of course "datefield" won't equal $month cuz I havn't formatted it in any way, so my question is, how do I format "datefield" within that query so that it is read as just a month name to be compared to $month...

thanks for any help

[chowdary]

Hi Eben,
Try this
$qry="SELECT * FROM $tablename WHERE DATE_FORMAT($dtfld,'%M')='$month'";

Make sure that $month values should be in full month i.e January,February,.....

Cheers
Ajay

[reagent]

do it the same way as your other query

WHERE DATE_FORMAT('%M', date) == $month

I haven't checked my syntax, so the DATE_FORMAT parameters may be out of order, but you get the idea

p.