How do I query a datetime for the current month?

[Catp00p]

I have tried this but it is returning value of 0... postdate is a datetime field and there are many records in the current month.

 

$query2 = "SELECT count(*) FROM news WHERE author = \'$newsPosterName\' AND posttime = MONTH(NOW())";

[Barand]

Almost

 

[php:1:135268d700]<?php

$query2 = \"SELECT count(*) FROM news WHERE author = \'$newsPosterName\' AND MONTH(posttime) = MONTH(NOW())\";

?>[/php:1:135268d700]

 

hth

 

EDIT : PS you might want to check the years are the same too