Re: 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" <joejava@dragoncat.net> wrote in message news:00b501c14db9$84e4a4f0$04a3d6d1@joeltklrijxxms... > > ----- Original Message ----- > From: "Andrey Hristov" <ahristov@icygen.com> > > > > 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: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >