Re: [PHP] 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 [EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Grab a range of rows from a mysql result
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 [EMAIL PROTECTED] 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 -- Travis Low mailto:[EMAIL PROTECTED] http://www.dawnstar.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Grab a range of rows from a mysql result
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