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 <start>,<offset> > > 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]
