diplsaying content categorized by month

[elduderino]

hi,

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??

[r937]

select year(articledate) as yy
     , month(articledate) as mm
     , other columns
  from ...
order
    by articledate desc

then check for control break on yy and mm as you loop over the query results

[elduderino]

hi rudy, thanks for the quick reply and the query.......now i cant think how to loop through with php and seperate the articles by month...... i know you cant help as you dont do PHP!

[spikeZ]

while($rows = mysql_fetch_assoc($query)) {
    if($flag !=$rows['mm']) {
        echo $rows['mm'] .'<br />';
    }
// echo the months
    echo $rows['article_title'] .'<br />';

    $flag = $rows['mm'];
} 

I have just chucked in some br's, format as you wish

[elduderino]

aha i see...thanks spikez