Re: Grab a range of rows from a mysql result

You might also want to try mysql_unbuffered_query(), Travis Low wrote:

select * from foo limit n, m n == starting index, zero-based m == maximum number of rows to return. You probably shouldn't cross-post to different mailing lists. cheers, Travis Info@Best-IT wrote:

I need to grab a range of rows from a mysql result resource. The resource is made up of 1000+ records from a mysql table that I am breaking up to make my PHP application run faster. I have figured out how to compute the range but I don¹t know how to pull out a group of rows within a range from a mysql result resource. Anyone have any insights into how I can do this in PHP? VR/Tim