|
From: Benjamin C. <bc...@us...> - 2002-03-20 15:59:28
|
Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv23168
Modified Files:
bug.php
Log Message:
Cleanup
Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.85
retrieving revision 1.86
diff -u -r1.85 -r1.86
--- bug.php 18 Mar 2002 17:43:15 -0000 1.85
+++ bug.php 20 Mar 2002 15:59:24 -0000 1.86
@@ -225,10 +225,10 @@
// If there are new comments grab the comments immediately before the latest
if ($comments or $newbug) {
- $rs = $db->query('select u.login, c.comment_text, c.created_date'
+ $rs = $db->limitQuery('select u.login, c.comment_text, c.created_date'
.' from '.TBL_COMMENT.' c, '.TBL_AUTH_USER.' u'
." where bug_id = {$buginfo['bug_id']} and c.created_by = u.user_id"
- .' order by created_date desc limit 2');
+ .' order by created_date desc', 0, 2);
$rs->fetchInto($row);
$t->set_var(array(
'newpostedby' => $row['login'],
|