[SOLVED] How would you do this...

[mike12255]

I have had a problem now for a while i tried playing around with the code and failed, i posted code on her and failed, so now im trying to ask how you would go about doing this and mabey i can get ideas.

 

Im sql'ing my database to get image locations and then i want to post X amount of pictures on a line and have it go down a line everytime the number X is reached.

 

Is that clear enough - if not ask questions

[.josh]

$cols = 5; // number of columns here
$count = 1;
while(some condition here that loops through results) {
   if ($count % $cols == 0) {
      echo "<br />"; // or close a tr and open a new one, etc..
      $count++;
   }
   //whatever code here

[mike12255]

whats this line do??

 

$count % $cols == 0)

 

never seen % used before

[.josh]

it's a modulus operator.  It divides one thing by another and returns the remainder.  The idea is if you divide the counter by the columns and it returns a zero remainder, you've reached a column count divisible by 5, or in other words, the 5th column in the current row, so start a new row.