Re: Grab a range of rows from a mysql result
| From: | Travis Low | Date: | Wed, 14 Jul 2004 03:18:57 +0000 |
| Subject: | Re: Grab a range of rows from a mysql result | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-190432@lists.php.net to get a copy of this message | ||
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-- Travis Low <mailto:travis@dawnstar.com> <http://www.dawnstar.com>