Creating multiple pages with DB info

[phpnewbie34]

Good afternoon fellow programmers,

I've been reading my reference book but I can't figure out to create more than one page for my list.

I want to create a simple list from my DB.

Then once I get to 100 titles I have a link that says NEXT

Then the next page has the next 100 titles

If you need to see my code I will send it

Thanks for your advice

[_uk_stuff]

Depending on what Database engine you are using, you will need to restrict the number of records returned. In MySQL this is done by adding a limit command to the SQL i.e.

SELECT Surname, Forename FROM users LIMIT 100;

You can then add more to the command to instruct MySQL to return 100 rows starting from a certain record i.e.

SELECT Surname, Forename FROM users LIMIT 300,100

In this example the result will start at record 301 and return 100 records. Therefore the link 'next' that you mention should state the record to begin at and then include this within the SQL being used.

[bradgrafelman]

The word you're looking for (and will want to search the forums and/or Google, as it is a topic that has been covered many times) is "pagination."