Re: next page records

On Friday 02 May 2003 20:00, Ryan A wrote: > 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. This kind of question gets asked every week or so. Search the php-db archives. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* As long as the answer is right, who cares if the question is wrong? */