database first last page 1 2 3 links how to ?

[Moon_Light]

I have split my database down to X number of records per page, but I dont know how to go back and forth between the pages, I ideally would like something that is on this forum i.e. Pages (26): [1] 2 3 » ... Last » but would settle form something more basic if it allows me to go back and forth between the pages.

I originally though this worked but after adding more than 10 entries I found out that it didn't after all. 🙁

$allmsg=$DBC->query_first("select count(gbook.id) as allmsg from gbook");

$pages =intval($allmsg[allmsg] / $rpp);

if ($allmsg[allmsg] % $rpb) {
	$pages++;
}
if ($pages>0) {
	echo "Show Page:";
}
for ($i=1;$i<=$pages;$i++) {
	$nav = $rpp*($i-1);
	echo " <a href=\"index.php?count=".$nav."\">".$i."</a>";
}
if (empty($count)) {
	$count=0;
}

[raymie]

Try http://www.phpbuilder.com/columns/rod20001214.php3

[Moon_Light]

oh right fantastic, i searched the forums never thought someone would of done an article on it 🙂

Thanks m8

[raymie]

Actually I did not know it was here either, I found the link on http://phpfaq.info/ which is always worth a look.

If you do not use usenet that it is also worth giving groups.google.com a search as well since the php groups on usenet are very helpful.

[Moon_Light]

Great thanks for the advice, I'll bookmark that for later much appreciated 🙂