[RESOLVED] Blog - making a monthly archive

[OniLink]

Hi,

I am in the middle of making a simple blog system. Anyway, I'm having trouble figuring out a way to make an archive list of months since the first blog article was submitted. I need it to be much like how WordPress has it:

August 2006
September 2006
October 2006
etc. etc.

How would I go about doing this? Do I determine the earliest article date, extract the month/year from that, and then list until I get to todays month/year? I really don't know how I would do that.

Thanks for any help,
~Oni.

[devinemke]

SELECT COUNT(*), YEAR(date) AS year, MONTH(date) AS month FROM table GROUP BY year, month ORDER BY year, month

[OniLink]

That's brilliant! How do I then change a month like 10 into October?

Thank you so much for your help!

[OniLink]

I've figured it out. Cheers.