|
From: Benjamin C. <bc...@us...> - 2003-03-27 13:25:45
|
Update of /cvsroot/phpbt/phpbt
In directory sc8-pr-cvs1:/tmp/cvs-serv4501
Modified Files:
query.php
Log Message:
Fixes bug 707559 - Join query with and rather than or
Index: query.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/query.php,v
retrieving revision 1.92
retrieving revision 1.93
diff -u -r1.92 -r1.93
--- query.php 18 Feb 2003 12:43:38 -0000 1.92
+++ query.php 27 Mar 2003 13:25:40 -0000 1.93
@@ -107,7 +107,7 @@
$flags[] = 'b.site_id in ('.@join(',',$site).')';
}
if (!empty($flags)) {
- $query[] = '('.@join(' or ',$flags).')';
+ $query[] = '('.@join(' and ',$flags).')';
}
// Email field(s)
@@ -316,7 +316,7 @@
'db_fields' => $desired_fields,
'field_titles' => $field_titles
));
-
+
$t->assign('bugs', $db->getAll($db->modifyLimitQuery(
sprintf($QUERY['query-list-bugs'], join(', ', $query_fields),
(!empty($HTTP_SESSION_VARS['queryinfo']['query'])
|