diff options
| author | pjmattal <pjmattal> | 2005-08-02 03:28:16 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2005-08-02 03:28:16 +0000 |
| commit | d9a2a5ea9978911f5a9ad051c19b3844ad2621b0 (patch) | |
| tree | 2550bfa97454cd64ed86cd92ae7594e35d5fd301 | |
| parent | 65b5c8b0deeb5be780d066949e9f1878b6c80f5d (diff) | |
fixed bug in the new update list where it doesn't list most of the updated packages, listing instead mostly new ones
| -rw-r--r-- | web/html/index.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/html/index.php b/web/html/index.php index cf365fc..d23ee35 100644 --- a/web/html/index.php +++ b/web/html/index.php @@ -132,7 +132,7 @@ print "<td class='boxSoft' valign='top'>"; #Hey, how about listing the newest pacakges? :D $q = "SELECT * FROM Packages "; $q.= "WHERE DummyPkg != 1 "; -$q.= "ORDER BY SubmittedTS DESC "; +$q.= "ORDER BY GREATEST(SubmittedTS,ModifiedTS) DESC "; $q.= "LIMIT 0 , 10"; $result = db_query($q,$dbh); # Table 2 |