Displaying Data Dependant on Month

[chrismellor]

I am trying to display seminar data for a particular month.

I managed to display all month in order

i.e
$sql="SELECT Code, Title, Speaker, DATE_FORMAT(date, '%d-%m-%y') FROM seminars2 GROUP BY month(date) ";

but I want only data for Specific Months to be displayed.

I.e List seminars due to take place in February [with (d,m,y) in date field displayed]

$sql="SELECT Code, Title, Speaker, DATE_FORMAT(date, '%d-%m-%y') FROM seminars2 WHERE MONTH = MONTH(MONTH(2))";

Please help

[devinemke]

for february:

$sql = "SELECT * FROM seminars2 WHERE MONTH(date) = 2";

note that this will return all records for the month of february regardless of year

[chrismellor]

Many thanks, it looks so simple after hours of grief.

CM