cvs: php-bugs-web / search.php

From: 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'";

« previous php.mirrors (#19001) next »