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