Do you mean you want to display for a particular userid a count of records per month/year?

If so the the following will do it in MySQL, similar constructs will work in Oracle, MS-SQL, Sybase etc. Let me know if this helps?


SELECT

count(*) as rowCount,

monthname(lastModifiedDate) as month,

year(lastModifiedDate) as year

FROM myTableName
WHERE userid = myUserid
GROUP by year(lastModifiedMate), monthname(lastModifiedDate)
ORDER BY year(lastModifiedDate), monthname(lastModifiedMate)