count data in current month in MySQL

dear all. i have a lot of data in my database. after that i have some MySQL code for counting data. i want to make them can count monthly.

how to make this code can count just in current month? its mean if now september, it was just co开发者_高级运维unting on this month. and the data from the other month is ignored. whats MySQL code to make it so that it can complete the code in the page link?

---

If you use the MySQL function NOW, you won't have to calculate the date in PHP:

WHERE YEAR(payment_date) = YEAR(NOW()) AND MONTH(payment_date) = MONTH(NOW())

---

where date < '09-30-2010' and date >= '09-01-2010'

---

WHERE MONTH(Inspection_datetime) = MONTH(CURRENT_DATE) 
AND YEAR(Inspection_datetime) = YEAR(CURRENT_DATE)