Re: Too many records to display in one web page
| From: | tedd | Date: | Sun, 27 May 2007 00:27:13 +0000 |
| Subject: | Re: Too many records to display in one web page | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255694@lists.php.net to get a copy of this message | ||
At 6:17 PM -0500 5/26/07, Eduardo Vizcarra wrote:
Hi All I am developing a web site that interacts with a MySQL database. When I run a query and display the records in a web page, this can become a problem because there might be too many records to be displayed in one single web page so I am trying to divide the total number of records and display them in multiple pages. Let's say, if the query returns 100 records then I would like to display the first 10 records and then put a navigation bar where I can go to the next 10 or return to the previous 10 records Is this done at a SQL or PHP level ? any experience on doing this ? Thanks a bunch EduardoEduardo: Yes, look into "LIMIT" in MySQL. Such as: $dbQuery="SELECT $id FROM $dbtable ORDER BY title LIMIT $offset, $rowsPerPage"; Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com