Help with while loop idea

[EchoFool]

I have the idea of a while loop with a query which is also in a while loop.. so in essence a while loop within a while loop. Now obviously that is do-able but the first main query i need to select rows in batches of 3's via ID for example.

 

$Get the first 3

While($row = ($Get)){

$row['ID']

$Find info on $row['ID']

While($row2 = ($Find)){

// stuff here

}

 

Now what needs to be added is a while loop around that whole thing so the "$Get the first 3" will essentially do this:

 

 

Get first 3

Get 4 to 6

Get 7 to 9

etc

 

But could not figure out how I could do this..... any suggestions?

[gigas10]

select * from table order by asc limit 3

select * from table where id > 3 order by asc limit 2

 

why would you even want to do this?

[bluejay002]

yeah... you can do this with query through LIMIT