Next and Previuos Links

[alsaffar]

Hi Guys,

I have a PHP guestbook and all the posts to my guestbook are posted in one page, so How can I make let's say 10 posts per page?

I took the guestbook php script from:

http://www.developers-resources.com/stories.php?story=01/11/22/0455791

Please feed me back

HaVe a GooD DaY 😉

Ali

[e-mail]

[phlow]

There is a piece of code on this page (see "Code Library") handeling this prob!

[alsaffar]

Hi,

What do you mean by "Code Library"? and what did you mean by this page?

Please clarify, so I can follow you 🙂

BeSt WiSheS 😉

Ali

[jayant]

Code Library is at http://www.phpbuilder.com/snippet/

Now for doing what you need to do,

Replace

SELECT * FROM guests

by

SELECT * FROM guests LIMIT $start,10

Just at the start of your PHP script give:

if(!isset($start)||$start=="") $start=0;

For giving next/prev links in guestbook:-

<a href="guestbook.php?start=<? echo $start-10; ?>">PREV</a>
<a href="guestbook.php?start=<? echo $start+10; ?>">NEXT</a>