cvs: pearweb /include pear-database.php
| From: | Thomas V.V.Cox | Date: | Tue, 15 Jan 2002 00:55:54 +0000 |
| Subject: | cvs: pearweb /include pear-database.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-1939@lists.php.net to get a copy of this message | ||
cox Mon Jan 14 19:55:54 2002 EDT
Modified files:
/pearweb/include pear-database.php
Log:
where was our "Show recent releases"? :-)
Index: pearweb/include/pear-database.php
diff -u pearweb/include/pear-database.php:1.39 pearweb/include/pear-database.php:1.40
--- pearweb/include/pear-database.php:1.39 Fri Dec 28 22:27:18 2001
+++ pearweb/include/pear-database.php Mon Jan 14 19:55:54 2002
@@ -349,7 +349,7 @@
function getRecent($n = 5)
{
global $dbh;
- $sth = $dbh->query("SELECT packages.id AS id, ".
+ $sth = $dbh->limitQuery("SELECT packages.id AS id, ".
"packages.name AS name, ".
"packages.summary AS summary, ".
"releases.version AS version, ".
@@ -357,11 +357,11 @@
"releases.releasenotes AS releasenotes, ".
"releases.doneby AS doneby ".
"FROM packages, releases ".
- "WHERE packages.name = releases.package ".
- "ORDER BY releases.releasedate DESC");
+ "WHERE packages.id = releases.id ".
+ "ORDER BY releases.releasedate DESC", 0, $n);
$recent = array();
- // XXX FIXME when DB gets rowlimit support
- while ($n-- > 0 && ($err = $sth->fetchInto($row, DB_FETCHMODE_ASSOC)) ===
DB_OK) {
+ // XXX Fixme when DB gets limited getAll()
+ while ($sth->fetchInto($row, DB_FETCHMODE_ASSOC)) {
$recent[] = $row;
}
return $recent;