Pager class problems
| From: | (Marc Logemann) | Date: | Tue, 04 Sep 2001 20:49:58 +0000 |
| Subject: | Pager class problems | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-1802@lists.php.net to get a copy of this message | ||
Hi,
i cant get pager doing is work right :)
------------ snip ------------------
$from = 0;
$row_per_page = 10;
$sql = "some sql";
if (DB::isError($res = $db->query($sql))){
die (DB::errorMessage($res));
}
$pager = new Pager ($res, $from, $rows_per_page);
$data = $pager->build();
if (DB::isError($data)){
die (DB::errorMessage($data));
}
while ($row = $pager->fetchRow()){
print_r($row);
}
--------------- snap ---------------
$row in the while loop wont get any data back from
fetchRow(). To be sure that the sql is ok i inserted
while ($row = $res->fetchRow()) { print_r($row);}
after the $db->query() and everything was fine. Is there
version conflict perhaps? I use the DB class from 4.0.6
and the Pager class was downloaded a few minutes ago.
I cant see any mistakes... perhaps i am working too much...
but perhaps its not my error :)
--
Marc Logemann (aka Loge, www.marc-logemann.de)