Wordpress archive list with year, month, days, posts and comment counts

archive, wordpress

Solution

You may want to consider performance issues related to query all your published posts.

I got a similar list, but displaying only the number of posts in each month, in total, I got 70 queries to the db, if I change it to display every post I got in that blog, the number goes up to 531 queries. (including other funcionality on the site, of course)

Montly list:

Every post list:

If you decide to go with the monthly list, you can use wp_get_archives.

[/end of warning]

If don't write that much and only got a few posts, you should look for something like this:

<ul class="years">
<?php
$all_posts = get_posts(array(
  'posts_per_page' => -1 // to show all posts
));

// this variable will contain all the posts in a associative array
// with three levels, for every year, month and posts.

$ordered_posts = array();

foreach ($all_posts as $single) {

  $year  = mysql2date('Y', $single->post_date);
  $month = mysql2date('F', $single->post_date);

  // specifies the position of the current post
  $ordered_posts[$year][$month][] = $single;

}

// iterates the years
foreach ($ordered_posts as $year => $months) { ?>
  <li>

    <h3><?php echo $year ?></h3>

    <ul class="months">
    <?php foreach ($months as $month => $posts ) { // iterates the moths ?>
      <li>
        <h3><?php printf("%s (%d)", $month, count($months[$month])) ?></h3>

        <ul class="posts">
          <?php foreach ($posts as $single ) { // iterates the posts ?>

            <li>
              <?php echo mysql2date('j', $single->post_date) ?> <a href="<?php echo get_permalink($single->ID); ?>"><?php echo get_the_title($single->ID); ?></a>  (<?php echo $single->comment_count ?>)</li>
            </li>

          <?php } // ends foreach $posts ?>
        </ul> <!-- ul.posts -->

      </li>
    <?php } // ends foreach for $months ?>
    </ul> <!-- ul.months -->

  </li> <?php
} // ends foreach for $ordered_posts
?>
</ul><!-- ul.years -->

Problem

Original source