I'm using DB and wonder how can I EASILY add results paging without changing my code much?
| From: | l Burnerheimerton | Date: | Thu, 30 Dec 2004 22:24:36 +0000 |
| Subject: | I'm using DB and wonder how can I EASILY add results paging without changing my code much? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-16529@lists.php.net to get a copy of this message | ||
Below is some code. I need to add apging to this page since it could list many items.
$res =& $db->query("SELECT ID, fName FROM names WHERE ID = 1
if (DB::isError($res)) {
die($res->getMessage());
}
while($row =& $res->fetchRow()) {
echo "<tr><a
href=\"op.php?i=$row[0]\">$row[1]</a></tr>";
}
Any ideas or code or links to read are much appreciated!
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.