gmdate MySQL field

[bart]

Hi,
I have a form that inputs the date using gmdate("dS M Y") into my mysql table. The date appears as 10th Sep 2002.

I want to be able to search my database for all records within a certain month. the drop down field to select a month will simply have the values Jan, Feb, Mar etc...

How can I pull all info from the database where the date field has the month chosen?

Thanks

P.S I know how to connect and retrieve data from the database. I just need to know how to match the month chosen with that specified in the customised date field.

[mayus]

is ur date field a varchar?

[bart]

sure is...

[mayus]

$month = ...

$ query = "SELECT * FROM table WHERE date like '%$month%'";

Basically says choose all rows that have string $month as part of the date.

Mayu