simple question...

[alan123]

This should be a simple question, how I can display mysql data on the browser page by page(one page has multiple data corresponding to one record in mysql, sorted by ID for example), it has "previous" and "next" link on that page, and on the first/last page the link can be hidden. anyone can give me some clue? thanks.

 

[sleipnir214]

You have to make use of MySQL's "LIMIT" clause in SELECT statements. If a SELECT query would return 1000 records, the LIMIT clause can tell MySQL to return rows 201-300, for example. This is documented in the MySQL online documentation on the page for the select statement:

http://www.mysql.com/doc/en/SELECT.html

In PHP, you pick a default page size, the number of records to display at a time. For the sake of argument, let's say we're going to display 25 records.

The script expects a GET-method input named "page" to tell it which set of 25 records to display. If it is not told which page to display, it assumes the first 25 records.

Each page of output will display a link back to the script it self, each like:

<a href=&quot;thescript.php?page=somenumber&quot;>

That somenumber will be the current page minus one (for a &quot;previous&quot; link) or the current page plus one (for a &quot;next&quot; link&quot. Since the script knows which set of records to display, it is pretty easy to not display the &quot;Previous&quot; link

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!