Yoshihisa Fukuhara
higef****@users*****
2006年 3月 19日 (日) 22:39:01 JST
Index: affelio/apps/diary/Diary.pm
diff -u affelio/apps/diary/Diary.pm:1.41 affelio/apps/diary/Diary.pm:1.42
--- affelio/apps/diary/Diary.pm:1.41 Fri Mar 3 20:54:03 2006
+++ affelio/apps/diary/Diary.pm Sun Mar 19 22:39:01 2006
@@ -262,7 +262,7 @@
}
# archives
- my @archives = $self->getall("SELECT DISTINCT year, month, count(id) as count_acvs FROM $self->{entry_table} GROUP BY year, month ORDER BY year,month DESC LIMIT 10");
+ my @archives = $self->getall("SELECT DISTINCT year, month, count(id) as count_acvs FROM $self->{entry_table} GROUP BY year, month ORDER BY year DESC, month DESC LIMIT 10");
if ($#archives >= 0) {
shift @archives unless $archives[0]->{year};
$tmpl_menu->param(ARCHIVES => \@archives);