DATE_FORMAT help please

[SeanTevlin]

hi i was wondering if anyone could tell me how compare a date in mysql to a php string, basically i want to select anything that is in the current month.

$month = date("m");

SELECT * FROM table WHERE DATE_FORMAT(datefield, '%m') = $m

I think im doing somthing backwards can anyone tell the correct way?

thanks
Sean

[devinemke]

you don't need PHP at all for this

SELECT * FROM table WHERE MONTH(datefield) = MONTH(CURDATE())