View Single Post
  #2 (permalink)  
Old 01-30-2007, 05:31 PM
Gary Bennion
 
Posts: n/a
Default MySQL answer. Re: Count entries per month?

Guys, I have found the anwer myself, put though i would post it incase its of interest to anyone else:

[sql]
SELECT MONTH(date_created), YEAR(date_created), COUNT(*)
FROM contact_requests
GROUP BY MONTH(date_created), YEAR(date_created)
[/sql]
Edit/Delete Message Reply With Quote