I have a database table with "items" in it. I have a menu with links. When you click on the "items" link you are taken to the "items" page. On this page are 20 items listed. Now I only want to display 20 items per page and then have a new page built to display 20 more items, these new pages will keep being built until no more items are left. At the bottom of each page should be a link structure showing which page of X they are on and a next and previous button to go to the previous or next 20 items. How do I setup something like this up? Thanks!
Its called pagination and there are loads of really good tutorials/examples about it. http://www.google.co.uk/search?hl=en&q=php+pagination&meta= Essentially you just alter the LIMIT 0,20 to LIMIT 20,40 etc in your query.