----- 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]