From 5e9f9b3633dda9470231b0ee5e6f40d8d6c84129 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 8 Apr 2001 10:35:48 +0000
Subject: - ... and order things by weight

---
 modules/book.module      | 2 +-
 modules/book/book.module | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'modules')

diff --git a/modules/book.module b/modules/book.module
index 86eb245e9..85f69d059 100644
--- a/modules/book.module
+++ b/modules/book.module
@@ -221,7 +221,7 @@ function book_admin() {
 function book_page() {
   global $status, $theme;
 
-  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = 0 AND n.status = $status[posted]");
+  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = 0 AND n.status = $status[posted] ORDER BY b.weight");
 
   while ($node = db_fetch_object($result)) {
     $output .= "<DT><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A></DT><DD>". check_output($node->body, 1) ."<BR><BR></DD>";
diff --git a/modules/book/book.module b/modules/book/book.module
index 86eb245e9..85f69d059 100644
--- a/modules/book/book.module
+++ b/modules/book/book.module
@@ -221,7 +221,7 @@ function book_admin() {
 function book_page() {
   global $status, $theme;
 
-  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = 0 AND n.status = $status[posted]");
+  $result = db_query("SELECT n.*, b.* FROM node n LEFT JOIN book b ON n.nid = b.nid AND n.lid = b.lid WHERE b.parent = 0 AND n.status = $status[posted] ORDER BY b.weight");
 
   while ($node = db_fetch_object($result)) {
     $output .= "<DT><A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A></DT><DD>". check_output($node->body, 1) ."<BR><BR></DD>";
-- 
cgit v1.2.3