How do I create a next link

[billmasters]

Hi,
I'm much of a beginner in php and I need help to create a Next link (much like the one Yahoo uses for your messages) for a site am designing. I want to limit the outputs from my database to say 25 outputs per page and the next 25 will be displayed onto the that same page with just minor refreshing.
Somebody pls help me 😕

[Dada78]

You are looking for pagination. Just look that up.

[billmasters]

Thanks for the quick reply Dada78
But where can I look it up or do u have a sample code I could just look @ to get the concept?

[ragedigital]

$displayPerPage = 10;

$_GET['pageSelected'];

$nextPageInfo = @mysql_query("SELECT * FROM myTable  LIMIT (($_GET['pageSelected']*$displayPerPage)-$displayPerPage) , $displayPerPage");

Should work...

EDIT: OOPS! Hit the wrong key! Had to EDIT the code...

[Dada78]

billmasters wrote:

Thanks for the quick reply Dada78
But where can I look it up or do u have a sample code I could just look @ to get the concept?

Check out this thread

http://phpbuilder.com/board/showthread.php?t=10350214

[billmasters]

Hey,
Thanks guys. Its working fine now.
I'm sure I'll enjoy this forum more than the yahoo group forum.
Thanks once again