Prev next links like article annotation in PHPBuilder

[warozzo]

how do I make a previous & next annotation/message links just like PHPBuilder article annotation (example: http://phpbuilder.com/annotate/message.php3?id=1010976).

Thanks.

[NogDog]

Search on "PHP pagination" and take a look at the PEAR Pager package.

[warozzo]

the common pagination techniques deal with query like:

$sql = "SELECT * FROM table LIMIT 0,5";

where from the display in the page link I mention I'm guessing it uses query like:

   $sql = "SELECT * FROM table WHERE message_id = 546546";

or am I guessing wrong?