Group posts by month ?

I have something similar on my blog – but I don’t show the date of each post: just the title.

<div id="post-<?php the_ID(); ?>" <?php post_class(); ?>>				<ul >
<?php
/**/
$years = $wpdb->get_col("SELECT DISTINCT YEAR(post_date) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY post_date ASC");
foreach($years as $year) :
?>

	<h4><li><a href="<?php echo get_year_link($year ); ?> "><?php echo $year; ?></a>
                <ul>
		<?php	$months = $wpdb->get_col("SELECT DISTINCT MONTH(post_date) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND YEAR(post_date) = '".$year."' ORDER BY post_date ASC");
			foreach($months as $month) :
		?>
			<h4><li><a href="<?php echo get_month_link($year, $month); ?>"><?php echo date( 'F', mktime(0, 0, 0, $month) );?></a>

		      <ul>
                          <?php  $theids = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND MONTH(post_date)= '".$month."' AND YEAR(post_date) = '".$year."' ORDER BY post_date ASC");
                      		foreach ($theids as $theid):	

			   ?>
                                <h4 style= font-style:italic;><li><a href="http://www.kittywake.us/?p=<?php echo $theid->ID; ?>"><?php echo $theid->post_title; ?></a></li></h4>                            

			<?php
				endforeach; ?>

			</ul>				  

	                </li></h4>

                         <?php endforeach;?>
              </ul>

        </li></h4>
<?php endforeach; ?>
       </ul>

			</div>
</div>

The only problem I have with this is that if someone clicks on the month name the posts are in descending order while the listing is in ascending. You might want to change the code to all DESC so that you don’t have this happen. I’m still working on a solution.

This does the almost the same thing as the code in my post above except that it now does so for custom taxonomies terms.

The query_posts and get_posts will check which custom taxonomy and taxonomy term the taxonomy page is on. Then show by selected year the date and posts for that custom taxonomy term. The date is retrieved automatically from the database. For now one still has to select the year (please see the description in my previous post for this.)

This code snippet is built to be used in taxonomy.php, and will only work with custom taxonomies.

Please see my previous post for more details.

<?php
	$term = get_term_by( 'slug', get_query_var( 'term' ), get_query_var( 'taxonomy' ) );
	$tt = $term->taxonomy . '=' . $term->slug;
	global $post;
	$query = 'numberposts=-1&' . $tt . '&orderby=date&order=DESC';
	$myposts =  get_posts();
	foreach($myposts as $post) {
		$year = get_the_time('Y');
		$title= $title= the_title('','',0);
		$groeps[] = $year;
	}

	$groeps = array_values(array_unique($groeps));
	$qi = $groeps[0]; // change this number (e.g. to 1) to change the year.
	$query = 'posts_per_page=-1&' . $tt . '&year=' . $qi .  '&orderby=date&order=DESC';
	query_posts($query);
	echo '<h4>' . $qi . '</h4>';
	while (have_posts()) :
	the_post();
	?>
 <?php the_date('F j','<h5>','</h5>'); ?>
 <?php the_title(); ?><br />
<?php endwhile; ?>

Feel free to improve.

Code has been written for WordPress version 2.8.6.

I figured it out on my own. If anyone is interested, here is a sample of the solution.

At the top of my template, before any loops, I have the following code to check to see what category the page I am on is and return its ID.

<?php foreach(get_the_category() as $category)
      { $thecat = $category->cat_ID; } ?>

Then, at the start of each loop I have the following. This code is set to call specific, constant post tags in respect to the particular category archive I am on.

<h2>30 Sheets</h2>
          <?php query_posts('cat=' . $thecat . '&tag=30-sheets&order=ASC'); ?>
          <?php if (have_posts()) : ?>
          <?php while (have_posts()) : the_post(); ?>

          ---- THE CONTENT YOU WANT TO SHOW GOES HERE ----

          <?php endwhile; ?>

          <?php else : ?>
          <div id="page">
          <p class="center">There are no records for this media.</p>
          </div>

          <?php endif; ?>

          <h2>Mall Kiosks</h2>
          <?php query_posts('cat=' . $thecat . '&tag=mall-kiosks&order=ASC'); ?>
          <?php if (have_posts()) : ?>
          <?php while (have_posts()) : the_post(); ?>

          ---- THE CONTENT YOU WANT TO SHOW GOES HERE ----

          <?php endwhile; ?>

          <?php else : ?>
          <div id="page">
          <p class="center">There are no records for this media.</p>
          </div>

          <?php endif; ?>

You can do this for as many loops and tags as you like.