cvs: php-bugs-web / search.php
| From: | Philip Olson | Date: | Sat, 28 Jun 2003 09:51:59 +0000 |
| Subject: | cvs: php-bugs-web / search.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-19001@lists.php.net to get a copy of this message | ||
philip Sat Jun 28 05:51:59 2003 EDT
Modified files:
/php-bugs-web search.php
Log:
Only mess with DISTINCT and bugdb_comments when doing an author_email search.
Index: php-bugs-web/search.php
diff -u php-bugs-web/search.php:1.42 php-bugs-web/search.php:1.43
--- php-bugs-web/search.php:1.42 Sat Jun 28 03:35:31 2003
+++ php-bugs-web/search.php Sat Jun 28 05:51:59 2003
@@ -33,7 +33,11 @@
else
$query = "SELECT ";
- $query .= "DISTINCT bugdb.*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb,
bugdb_comments ";
+ if (empty($author_email)) {
+ $query .= "*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb ";
+ } else {
+ $query .= "DISTINCT bugdb.*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb,
bugdb_comments ";
+ }
if ($bug_type == "Any") {
$where_clause = "WHERE bug_type != 'Feature/Change Request'";