From 864262c2ab49981990074f2d289c80365196bddf Mon Sep 17 00:00:00 2001 From: "Paul S. Owen" Date: Fri, 2 Mar 2001 01:31:39 +0000 Subject: MySQL compatibility update of MSSQL compability. git-svn-id: file:///svn/phpbb/trunk@71 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/viewforum.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'phpBB/viewforum.php') diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php index 111502c7df..90b092df67 100644 --- a/phpBB/viewforum.php +++ b/phpBB/viewforum.php @@ -70,7 +70,7 @@ if(!isset($start)) $start = 0; } -$sql = "SELECT t.*, u.username, p.post_time FROM " . TOPICS_TABLE ." t JOIN ". USERS_TABLE. " u ON t.topic_poster = u.user_id LEFT JOIN ".POSTS_TABLE." p ON p.post_id = t.topic_last_post_id WHERE t.forum_id = '$forum_id' ORDER BY topic_time DESC LIMIT $start, $topics_per_page"; +$sql = "SELECT t.*, u.username, p.post_time FROM " . TOPICS_TABLE ." t INNER JOIN ". USERS_TABLE. " u ON t.topic_poster = u.user_id LEFT JOIN ".POSTS_TABLE." p ON p.post_id = t.topic_last_post_id WHERE t.forum_id = '$forum_id' ORDER BY topic_time DESC LIMIT $start, $topics_per_page"; if(!$t_result = $db->sql_query($sql)) { error_die($db, QUERY_ERROR); -- cgit v1.2.1