[PHP] Paging through MySQL results in PHP

I have an application that returns a set of results from a MySQL query. Let's say I have 100 results from the query, but only want to show 25 per HTML page. The MySQL query is driven by a 'Search' page that creates an array "$keywords" - which can be of any size. I then loop through the $ke

Re: [PHP] Paging through MySQL results

Question: Does the pagination method using mysql_data_seek method pull in the entire result set, only to be used to display x number of rows? "Joel Ricker" <[EMAIL PROTECTED]> wrote in message 00b501c14db9$84e4a4f0$04a3d6d1@joeltklrijxxms">news:00b501c14db9$84e4a4f0$04a3d6d1@joeltklrijxxms... >

Re: [PHP] Paging through MySQL results

- Original Message - From: "Andrey Hristov" <[EMAIL PROTECTED]> > select * from some_table Limit 10,30; Something to point out, in some of the older versions of MySQL, Offset starts counting at 0, while in the newer versions, it starts counting at 1. You'll want to check the documentat

Re: [PHP] Paging through MySQL results

select * from some_table Limit 10,30; syntaxis limit , Andrey Hristov IcyGEN Corporation Building Solutions On Friday 05 October 2001 18:52, you wrote: > I am a bit new to PHP -- normally use ASP (no booing, please) -- and trying > to find an elegant solution to paging x number of records at a t

[PHP] Paging through MySQL results

I am a bit new to PHP -- normally use ASP (no booing, please) -- and trying to find an elegant solution to paging x number of records at a time through a result set returned to a php page from MySQL. Any ideas? TIA, Bill -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mai