07-30-2010, 05:02 AM
[eluser]tusukgigi[/eluser]
if anyone other than this query?
SELECT dateflag, COUNT(*) AS num_stats
FROM stat
WHERE MONTH(dateflag)=MONTH(NOW()) AND YEAR(dateflag)=YEAR(NOW())
result :
dateflag | num_stats
2010-07-22 | 800
if anyone other than this query?
SELECT dateflag, COUNT(*) AS num_stats
FROM stat
WHERE MONTH(dateflag)=MONTH(NOW()) AND YEAR(dateflag)=YEAR(NOW())
result :
dateflag | num_stats
2010-07-22 | 800