07-30-2010, 02:22 AM
[eluser]mddd[/eluser]
If you want to get all the data for the current month, just use
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())