Entry

How do I list 500 results in muliples of 10 without having to search the database for each result set(1-10,11-21, etc)?

Jul 26th, 2000 16:58
Evan Heller, Jeremy Gillick,

select blah from x where Z limit 0,10
for the next one you do the same except limit 10,10 and so forth
limit 20,10  limit 30,10
each time it would get exactly 10 results, each time 10 higher.