mysql date range in query

[condoug]

Hi all

For each record in my database table, there is a publishdate and expirydate field.

So a typical record might have the following:

title = 'My Test Article'
publishdate = '2009-01-10'
expirydate = '2009-09-24'

On my Article form I have a listbox that lists the months January to December each with their option values set to 01, 02, 03, 04 respectively.

When I POST this form, is there a way I can use the chosen listbox value (for example 06 = June) to display only those records in my table that have a date range that would suggest it was LIVE during the month which was posted? (the example above being June).

I hope that akes sense.

Kind regards
Doug

[bradgrafelman]

Does the dropdown also include a year selector, or is it assumed to be the current year only? If the latter is the case, you could do a query like so:

$month = (int)$_POST['month'];
$query = "SELECT title FROM myTable WHERE '" . date('Y') . "-$month' BETWEEN publishdate AND expirydate";

utilizing MySQL's BETWEEN syntax (assuming you're using MySQL).