cvs: phpweb / bugs.php
| From: | Simon Roberts | Date: | Mon, 23 Oct 2000 03:43:32 +0000 |
| Subject: | cvs: phpweb / bugs.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-2601@lists.php.net to get a copy of this message | ||
lyric Sun Oct 22 20:43:32 2000 EDT
Modified files:
/phpweb bugs.php
Log:
Better algorithm for selecting bugs by date?
Index: phpweb/bugs.php
diff -u phpweb/bugs.php:1.62 phpweb/bugs.php:1.63
--- phpweb/bugs.php:1.62 Sun Oct 22 19:58:59 2000
+++ phpweb/bugs.php Sun Oct 22 20:43:32 2000
@@ -507,7 +507,7 @@
}
// not supported by the HTML form yet : use the URL :)
if(isset($bug_age) && ($bug_age!="All")) {
- $where_clause .= " and (TO_DAYS(NOW())-TO_DAYS(ts1))<=$bug_age";
+ $where_clause .= " and ts1 >= date_sub(now(), interval $bug_age day)";
}
if (strlen($where_clause)) {
$where_clause .= " and";