Index: editcomment.php =================================================================== --- editcomment.php (revision 1277) +++ editcomment.php (working copy) @@ -2,7 +2,7 @@ /*=====================================================================*\ || ################################################################### || # Bugdar [#]version[#] -|| # Copyright ©2002-[#]year[#] Blue Static +|| # Copyright 2002-[#]year[#] Blue Static || # || # This program is free software; you can redistribute it and/or modify || # it under the terms of the GNU General Public License as published by @@ -73,7 +73,7 @@ { $lastgoodpublic = $db->query_first(" SELECT comment.* AS comment, user.displayname AS username - FROM " . TABLE_PREFIX . "comment + FROM " . TABLE_PREFIX . "comment AS comment LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = comment.userid) WHERE bugid = $bug[bugid] @@ -81,7 +81,7 @@ "); $lastgoodprivate = $db->query_first(" SELECT comment.* AS comment, user.displayname AS username - FROM " . TABLE_PREFIX . "comment + FROM " . TABLE_PREFIX . "comment AS comment LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = comment.userid) WHERE bugid = $bug[bugid] @@ -151,7 +151,7 @@ $lastgood = $db->query_first(" SELECT comment.* AS comment, user.displayname AS username - FROM " . TABLE_PREFIX . "comment + FROM " . TABLE_PREFIX . "comment AS comment LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = comment.userid) WHERE bugid = $bug[bugid]