RE: [PHP] Too many records to display in one web page

2007-05-27 Thread Brian Seymour
records to display in one web page Brian Seymour wrote: > Eduardo, > The best way to do it is on both a php and sql level. Use sql's limit > keyword in your query to return only the amount of records you want. For > instance, page 1 will have LIMIT 0, 9 in the query. Page 2 will ha

Re: [PHP] Too many records to display in one web page

2007-05-26 Thread Jim Lucas
Brian Seymour wrote: Eduardo, The best way to do it is on both a php and sql level. Use sql's limit keyword in your query to return only the amount of records you want. For instance, page 1 will have LIMIT 0, 9 in the query. Page 2 will have LIMIT 10, 19. Then you can simply use *_fetch_array and

Re: [PHP] Too many records to display in one web page

2007-05-26 Thread tedd
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 try

RE: [PHP] Too many records to display in one web page

2007-05-26 Thread Brian Seymour
Eduardo, The best way to do it is on both a php and sql level. Use sql's limit keyword in your query to return only the amount of records you want. For instance, page 1 will have LIMIT 0, 9 in the query. Page 2 will have LIMIT 10, 19. Then you can simply use *_fetch_array and a foreach(maybe) to it

Re: [PHP] Too many records to display in one web page

2007-05-26 Thread Tijnema
On 5/27/07, Eduardo Vizcarra <[EMAIL PROTECTED]> 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