Create summary list
If you have SQL table named Messages, with DateStamp having dates, you can then create a Posts-Per-YearMonth list as summary using SQL below
Something that I use to build a Posts-Per-YearMonth list in most of my websites
SELECT yoyo, Momo, SUM(coco1) AS coco FROM (
SELECT YEAR(DateStamp) AS yoyo, Month(DateStamp) As Momo, COUNT(*) AS coco1 FROM Messages GROUP BY DateStamp
) AS derivedtbl_1
GROUP BY yoyo, Momo
ORDER BY yoyo DESC, Momo Desc
SELECT YEAR(DateStamp) AS yoyo, Month(DateStamp) As Momo, COUNT(*) AS coco1 FROM Messages GROUP BY DateStamp
) AS derivedtbl_1
GROUP BY yoyo, Momo
ORDER BY yoyo DESC, Momo Desc
Views 3,245
Downloads 1,195
CodeID
DB ID
ANmarAmdeen
602
Revisions
v1.0
Saturday
December
15
2018