RE: [PHP] next page records

Hi Ryan, Here is an article I wrote on the subject, should get you going. http://www.devshed.com/Server_Side/PHP/Paginating/page1.html HTH Ade www.phpscriptsearch.com -----Original Message----- From: Ryan A [mailto:ryan@jumac.com] Sent: 02 May 2003 13:00 To: php-general@lists.php.net Subject: [PHP] next page records Hey ppl, Just a small simple question (I hope), I have made a little front end for the "admin" to see all the records in the database..till now everything is working fine but when the records are over 20 theres a problem most probably because of the "limit" in MySql...does anybody know how that "next page" feature works? eg: if there are more than 20 records in the database there should be a link below that says "next page" (if there are less than 20 records no link should be shown or the link should be "disabled") and when the client clicks on it he gets the next 20 records plus there should be a "previous page" link etc etc I have seen this on many sites (including google) and I am pretty sure its done with "count" in mySql but am getting lost somewhere in the logic... Kindly reply with a small code example if possible or somewhere where I can read up on it. Cheers, -Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php