OMG, how lame could those other sites be
Originally Posted by Codiah
your problem, and the solution, is at the novice level, there's nothing particularly difficult about it
by the way, you wanted month names, right?
you'll need to use this --
notice that in order to include MONTHNAME in the SELECT clause, you need to include it in the GROUP BY clause
SELECT MONTHNAME(post_date) -- display this
, MONTH(post_date) -- and ignore this in the display
actually, you don't need both MONTHNAME and MONTH in the GROUP BY clause in mysql, but ignore this non-standard anomaly for now
you do, however, need to include MONTH in the ORDER BY clause (so as to get the proper sequencing), and therefore you also need to include it in the SELECT clause
maybe a bit beyond novice level after all...