Sql results on multiple pages

[lrbarahona]

Hello all,

I was wondering what kind of approach can be used to display a sql query on multiple pages. For example, if the query results in more than five results I want the page to create a link to a 2nd page where results 6+ will be displayed.

[coldfire421]

what you want to happen is something like pagination. try to see this links

http://www.phpfreaks.com/tutorial/basic-pagination