From d03f42c35f9d37ad688ed4982054d0efdf64352a Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 15 Dec 2001 16:41:51 +0000
Subject: - Fixed typo.

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

(limited to 'modules/page/page.module')

diff --git a/modules/page/page.module b/modules/page/page.module
index af5fb1795..03925a1e3 100644
--- a/modules/page/page.module
+++ b/modules/page/page.module
@@ -53,7 +53,7 @@ function page_load($node) {
 
 function page_link($type) {
   if ($type == "page") {
-    $result = db_query("SELECT nid, link FROM page WHERE status = '1' AND link != '' ORDER BY link");
+    $result = db_query("SELECT n.nid, p.link FROM page p LEFT JOIN node n ON p.nid = n.nid WHERE n.status = '1' AND p.link != '' ORDER BY p.link");
     while ($page = db_fetch_object($result)) {
       $links[] = "<a href=\"node.php?id=$page->nid\">$page->link</a>";
     }
-- 
cgit v1.2.3