From 6ca6e831b6593a04c017cbb8687a47247bf9559f Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 31 Mar 2001 17:56:12 +0000
Subject: - fixed bug in section.module: id -> nid - fixed bug in book.module:
 not 100% yet

---
 modules/section.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/section.module')

diff --git a/modules/section.module b/modules/section.module
index 07054903e..9b42e46d1 100644
--- a/modules/section.module
+++ b/modules/section.module
@@ -18,7 +18,7 @@ function section_help() {
 }
 
 function section_block() {
-  $result = db_query("SELECT se.name, COUNT(st.id) AS stories FROM sections se LEFT JOIN story st ON se.name = st.section GROUP BY se.name");
+  $result = db_query("SELECT se.name, COUNT(st.nid) AS stories FROM sections se LEFT JOIN story st ON se.name = st.section GROUP BY se.name");
   while ($_section = db_fetch_object($result)) {
     $content .= "<LI><A HREF=\"?section=". urlencode($_section->name) ."\">$_section->name</A> (". check_output($_section->stories, 0) .")</LI>\n";
   }
-- 
cgit v1.2.3