diff options
| author | Kjartan Mannes <kjartan@2.no-reply.drupal.org> | 2002-05-20 09:19:43 +0000 |
|---|---|---|
| committer | Kjartan Mannes <kjartan@2.no-reply.drupal.org> | 2002-05-20 09:19:43 +0000 |
| commit | 3d5d2476904a97de5ed822085c76666d0c411784 (patch) | |
| tree | b3a79ec98cce85965b6846982e0c57bb8256e41d /modules/node.module | |
| parent | f3c875717910918574aa1310de176e0c44062199 (diff) | |
| download | brdo-3d5d2476904a97de5ed822085c76666d0c411784.tar.gz brdo-3d5d2476904a97de5ed822085c76666d0c411784.tar.bz2 | |
- changing sort order.
Diffstat (limited to 'modules/node.module')
| -rw-r--r-- | modules/node.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/node.module b/modules/node.module index e06d1a815..8419f2ba4 100644 --- a/modules/node.module +++ b/modules/node.module @@ -1233,7 +1233,7 @@ function node_page() { $result = db_query("SELECT n.nid, type, count(*) AS c FROM node n LEFT JOIN term_node r ON n.nid = r.nid WHERE tid IN (".implode(",", $terms).") AND ". ($id ? "nid = '$id'" : "promote = '1'") ." AND status = '1' GROUP BY n.nid HAVING c = ".count($terms)." ORDER BY static DESC, created DESC LIMIT ". ($user->nodes ? $user->nodes : variable_get("default_nodes_main", 10))); } else { - $result = db_query("SELECT nid, type FROM node WHERE ". ($id ? "nid = '$id'" : "promote = '1'") ." AND status = '1' ORDER BY static DESC, changed DESC LIMIT ". ($user->nodes ? $user->nodes : variable_get("default_nodes_main", 10))); + $result = db_query("SELECT nid, type FROM node WHERE ". ($id ? "nid = '$id'" : "promote = '1'") ." AND status = '1' ORDER BY static DESC, created DESC LIMIT ". ($user->nodes ? $user->nodes : variable_get("default_nodes_main", 10))); } while ($node = db_fetch_object($result)) { |