[phpBT-dev] CVS: phpbt index.php,1.25,1.26

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv15731

Modified Files:
	index.php 
Log Message:
Cleanup

Index: index.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/index.php,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -r1.25 -r1.26
--- index.php	27 Mar 2002 23:19:07 -0000	1.25
+++ index.php	28 Mar 2002 22:26:06 -0000	1.26
@@ -141,8 +141,8 @@
 
 	$rs = $db->query("$querystring, count(bug_id) as \"Total\" from ".TBL_BUG.
 		" b left join ".TBL_PROJECT." p using (project_id)".
-		" where b.project_id not in ($restricted_projects) group by b.project_id".
-		" order by project_name");
+		" where b.project_id not in ($restricted_projects) group by b.project_id,".
+		" project_name order by project_name");
 	if (!$rs->numRows()) {
 		$t->set_var('projblock', '');
 	} else {
@@ -186,11 +186,11 @@
 if (DB::isError($rs) or !$rs->numRows()) {
 	$t->set_var('recentrows', $STRING['nobugs']);
 } else {
-	while (extract($rs->fetchRow())) {
+	while ($rs->fetchInto($recent)) {
 		$t->set_var(array(
-			'title' => stripslashes($title),
-			'bugid' => $bug_id,
-			'project' => stripslashes($project_name)
+			'title' => stripslashes($recent['title']),
+			'bugid' => $recent['bug_id'],
+			'project' => stripslashes($recent['project_name'])
 		));
 		$t->parse('recentrows', 'recentrow', true);
 	}
@@ -204,11 +204,11 @@
 if (DB::isError($rs) or !$rs->numRows()) {
 	$t->set_var('closerows', $STRING['nobugs']);
 } else {
-	while (extract($rs->fetchRow())) {
+	while ($rs->fetchInto($closed)) {
 		$t->set_var(array(
-			'title' => stripslashes($title),
-			'bugid' => $bug_id,
-			'project' => stripslashes($project_name)
+			'title' => stripslashes($closed['title']),
+			'bugid' => $closed['bug_id'],
+			'project' => stripslashes($closed['project_name'])
 		));
 		$t->parse('closerows', 'closerow', true);
 	}