diff options
| -rw-r--r-- | modules/page.module | 2 | ||||
| -rw-r--r-- | modules/page/page.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/page.module b/modules/page.module index af5fb1795..03925a1e3 100644 --- a/modules/page.module +++ b/modules/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>"; } 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>"; } |