I have a query which is using a date function to format an article date by month/year. My query is:
SELECT `ID`, `title`, `content`, `articleDate`, `pdfDoc`, date_format(articleDate, '%M %Y') as monthYear from articles ORDER BY articleDate DESC";
The query is working fine, but I cannot figure out how to output it on screen grouped by month/year. I need it to look something like the following:
August 2009
- Article Title
- Article Title
September 2009
- Article Title
- Article Title
I am a ColdFusion programmer who is trying to learn PHP and this is beyond my skill level right now...
Thank you!