is there any way to view a range of results in mysql, and by that i mean is there any way i can see the first 100 results of a query or the 50th through 100th results of a query.
is there any way to do that? i read about using views, but i didnt see anything about viewing a certain number of results.
should i just feed my results into an array in php, and then sift through the array?
thanks a lot.