diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-12-15 16:41:51 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-12-15 16:41:51 +0000 |
| commit | d03f42c35f9d37ad688ed4982054d0efdf64352a (patch) | |
| tree | 0a3c92b7b33fe02dfdf565e9b964efd3d6c1d287 /modules | |
| parent | eea53076d9471e360f318819f117f33dfdf5bd42 (diff) | |
| download | brdo-d03f42c35f9d37ad688ed4982054d0efdf64352a.tar.gz brdo-d03f42c35f9d37ad688ed4982054d0efdf64352a.tar.bz2 | |
- Fixed typo.
Diffstat (limited to 'modules')
| -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>"; } |