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... > > - 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 documentation for your version. > > Joel > > > 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 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-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 documentation for your version. Joel > 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 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-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 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-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]