Need to put blog archives in date order

[TheHarriets]

Hi

 

Here's a snippet of code to display blog archives by months:

<section class="category2">
  <h1>Archives</h1>
  <ul>
    <? for($i=0;isset($yearRecord[$i]);$i++){?><li><a <?php if($year= $yearRecord[$i]->month) {?>class="active" <?php }?> href="<?=site_url('blog-archives').'/'.$yearRecord[$i]->month.'-'.$yearRecord[$i]->year?>" hidefocus="true" style="outline: medium none;"><span><?=$yearRecord[$i]->month?> <?=$yearRecord[$i]->year?> </span></a></li>
    <? }?>
  </ul>
</section>

However this displays the months with posts in alphabetic order, like this..

Archives

• August 2015
• July 2015
• June 2015
• October 2015
• September 2015

 

How can I change the code so that the months display in chronological order?

 

Can anyone help please?

 

Thanks

Andy

[scootstah]

You change the query to use an ORDER BY clause on the date field.