Ive googled this but im not getting the answer im after....basically i want to make an archive page so that i can show all the title of my articles in order of which month they were posted in.
Im using mysql NOW() function to insert the date in to the db so is there any easy way i can select from the db and order by month.
Basically what i want is to have a definition list with the month and then a list of article titles from that month below..
any ideas anyone??