Viewing MySQL Data question...

[Anon]

Hello,
I am in the process of building a custom user managment php script for my website. I am suprised by how far I have gotten. I have learned how to use PHP Sessions, and they are very usefull. However, my users will need to view the things that they posted into the database. How do I make a php script so that when the information is requested from the database, it only displays 15 items, and the user has to click a "Next page..." button to see another set of 15 items? Thanks for your help in advance.

-Mike

[philsown]

With mysql you can use the LIMIT clause. Look it up in the docs. Based on that you can pass variables in a query string that affect the limit.

[Anon]

Check out the many good articles on this site. The answer to your question, and probably many others you will run into are already there:

http://www.phpbuilder.com/columns/rod20000221.php3