Tepi, I gotta be honest, I'm having a helluva time understanding what you are talking aobut, but I'll make a suggestion thinking you mean: you want to cycle through a result set one LIMIT at a time:
Use offset. ie
select * from table order by field limit 25 offset 33
will give you the 25 records starting at position 33 in the result set.
Sorry if misunderstood if I'm wrong.