[phpBT-dev] CVS: phpbt bug.php,1.42,1.43

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

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

Modified Files:
	bug.php 
Log Message:
Grab only the project information

Index: bug.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/bug.php,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -r1.42 -r1.43
--- bug.php	2001/09/18 03:36:33	1.42
+++ bug.php	2001/09/18 03:43:06	1.43
@@ -506,9 +506,9 @@
 
 function show_projects() {
 	global $me, $q, $t, $project, $STRING;
-	
+	$q->Debug=true;
 	// Show only active projects with at least one component
-	$q->query('select * from '.TBL_PROJECT.' p, '.TBL_COMPONENT
+	$q->query('select p.* from '.TBL_PROJECT.' p, '.TBL_COMPONENT
 		.' c where p.active and p.project_id = c.project_id group by p.project_id 
 		order by project_name');
 	switch ($q->num_rows()) {