From f295648cb12b574c03862e0a6fb11ed7218657b0 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 17 Oct 2001 18:18:35 +0000 Subject: - fixed a SQL typo in node.php: user --> users - added SQL table keys for the node types --- node.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'node.php') 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)) { -- cgit v1.2.3