[RESOLVED] Use date in MySQL Query Help

[condoug]

Hi all

I have a form which consists of 2 drop down menus.

1) a list of years (e,g, 2008 through to 2015
2) a list of months (Jan to Dec)

A user can choose a value from either list box and I post the form and I need to query the database based on the values chosen and only retrieve those records that are assigned to the date selected above.

So my question is, is it possible to take the two values e.g:

Year = 2010
Month = 08

and use these directly in the MYSQL query to only select the records of the database that match the date range?

The date stored against each records is formatted as: 2010-08-02

Thanks for reading

Doug

[bradgrafelman]

Sure; you can use MySQL's MONTH() and YEAR() functions in the WHERE clause to select dates that match the given values.