Question Regarding while() and MySQL

[carsonk]

Hi,

 

I'm wondering what would be the most efficient way to go through, loop through the first three rows of a MySQL Table, then do something different on the fourth, fifth, sixth, and change back again on the seventh. I would like this pattern to continue until all the tables are used up. I would also like to make sure it can not only end on a number that is divisible by three, like fourteen.

 

Thanks!

[premiso]

Using an incrementor and the modulus operator to determine if there is a remainder.

 

IE:

for ($i=0; $i<8; $i++) {
    if ($i % 3 == 0) {
          echo 'Third Row<br />';
    }else {
          echo 'Other rows!';
    }
}

 

Should give you a starting point for how your logic needs to be with modulus.