boardom

[mikelittle]

Here's another. This one gives you total posts for the month/week in your archives list by month/week

in b2archives.php

the code

[mikelittle]

Minor update: I believe count(column) is more efficient than count(*);
[php:1:de843ce355]<?php
if ($archive_mode == 'monthly') {
$arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), count(ID) as posts FROM $tableposts WHERE post_date < '$now' AND post_category > 0 GROUP BY MONTH(post_date) ORDER BY post_date DESC";
$querycount++;
$arc_result=mysql_query($arc_sql) or die($arc_sql.'<br />'.mysql_error());
while($arc_row = mysql_fetch_array($arc_result)) {
$arc_year = $arc_row['YEAR(post_date)'];
$arc_month = $arc_row['MONTH(post_date)'];
echo "<a href=\"$archive_link_m$arc_year".zeroise($arc_month,2).'">';
echo $month[zeroise($arc_month,2)].' '.$arc_year;
echo '</a>';
echo ' (' . $arc_row['posts'] . ' post' . (($arc_row['posts'] > 1) && ($arc_row['posts'] != 0) ? 's' : '') .')';
echo $archive_line_separator."\n";
}
//skip daily section
} elseif ($archive_mode == 'weekly') {
if (!isset($start_of_week)) {
$start_of_week = 1;
}
$arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date), WEEK(post_date), count(ID) as posts FROM $tableposts WHERE post_date < '$now' AND post_category > 0 GROUP BY WEEK(post_date) ORDER BY post_date DESC";
$querycount++;
$arc_result=mysql_query($arc_sql) or die($arc_sql.'<br />'.mysql_error());
$arc_w_last = '';
while($arc_row = mysql_fetch_array($arc_result)) {
$arc_year = $arc_row['YEAR(post_date)'];
$arc_w = $arc_row['WEEK(post_date)'];
if ($arc_w != $arc_w_last) {
$arc_w_last = $arc_w;
$arc_ymd = $arc_year.'-'.zeroise($arc_row['MONTH(post_date)'],2).'-' .zeroise($arc_row['DAYOFMONTH(post_date)'],2);
$arc_week = get_weekstartend($arc_ymd, $start_of_week);
$arc_week_start = date_i18n($archive_week_start_date_format, $arc_week['start']);
$arc_week_end = date_i18n($archive_week_end_date_format, $arc_week['end']);
echo "<a href=\"$siteurl/".$blogfilename."?m=$arc_year&w=$arc_w\">";
echo $arc_week_start.$archive_week_separator.$arc_week_end;
echo '</a>';
echo ' (' . $arc_row['posts'] . ' post' . (($arc_row['posts'] > 1) && ($arc_row['posts'] != 0) ? 's' : '') .')';
echo $archive_line_separator."\n";
}
}
?>[/php:1:de843ce355]

Note: I've skipped the daily section

[sharmaine]

This is great! Thank you so much!