Rows of $X amount of columns

netfrugal

So, I have a bunch of nice images (thumbnails) of cool things. And it's quite easy to list them with repeating rows, while in one column.

I've looked for a way to show the thumbnails 5 across at a time, while creating a new row of 5 more until there are no more to show.

Haven't had much luck!

If anyone has had some success in this, please send some pointers to me.

I'll append some code below of the regular way I'm repeating the thumbnails.

So, any help is totally appreciated!

<? 
$sql = mysql_query("SELECT * FROM thumbnails"); 
    while ($row = mysql_fetch_array($sql)) {
    $img = $row['img'];
?>
<tr><td><? echo $img; ?></td></tr>
<? } ?>

Nothing too serious. But I'm stumped on making some columns out of this.

examancer

there are many ways to accomplish what you want. here is one quick&dirty example.

<tr><? // <-- notice first row starts here 
$y=0;$columnMax=5; // initialize... not really necessary but good idea
$sql = mysql_query("SELECT * FROM thumbnails"); 
while ($row = mysql_fetch_array($sql)) {
  $img = $row['img'];
  $y++;
  if ($y > $columnMax) { $y=0; ?></tr><tr><? } // start new row
  ?>
  <td><? echo $img; ?></td>
  <?
}
?></tr><!-- last row closed here -->

Could be errors there as I haven't tested it, but that's general idea.

Weedpacket

http://phpbuilder.com/board/showthread.php?t=10262518