how to generate queries based on date

[eluser]mddd[/eluser]
If you want to get all the data for the current month, just use

Code:

SELECT dateflag, COUNT(*) AS num_stats
FROM stat
WHERE MONTH(dateflag)=MONTH(NOW()) AND YEAR(dateflag)=YEAR(NOW())