- fixed a SQL typo in node.php: user --> users

- added SQL table keys for the node types

1 files changed, 1 insertions, 1 deletions

diff --git a/node.php b/node.php
index e79e551fc..f80b25373 100644
--- a/node.php
+++ b/node.php
@@ -88,7 +88,7 @@ function node_history($node) {
 $number = ($title ? db_num_rows(db_query("SELECT nid FROM node WHERE title = '$title' AND status = '". node_status("posted") ."'")) : 1);
 
 if ($number > 1) {
-  $result = db_query("SELECT n.*, u.name, u.uid FROM node n LEFT JOIN user u ON n.uid = u.uid WHERE n.title = '$title' AND n.status = '". node_status("posted") ."' ORDER BY timestamp DESC");
+  $result = db_query("SELECT n.*, u.name, u.uid FROM node n LEFT JOIN users u ON n.uid = u.uid WHERE n.title = '$title' AND n.status = '". node_status("posted") ."' ORDER BY timestamp DESC");
 
   while ($node = db_fetch_object($result)) {
     if (node_access($node)) {