Displaying and organising images.

[lifeasalounge]

I have this code:

include "connFiles/ConnVar.php";
include "connFiles/ConnSelect.php";
include "connFiles/ConnSelectDB.php";

$query = "SELECT id, photo, description, postdate FROM photos WHERE albumid = '$albumid'";
$result = mysql_query($query) or die('Cannot retrieve from database');

 while($row = mysql_fetch_row($result)) {

   $id = $row[0];
   $photo = $row[1];
   $description = $row[2];
   $postdate = $row[3];

?>

<td valign="middle" id="cell_thumbs"><a href="viewPhoto.php?id=<?php echo "$id"; ?>"><img src="<?php echo "$photo"; ?>" alt="" width="133" height="100" border="0" class="thumbs"></a></td>

<?php
}
?>

This displays my images in columns accross the page. I want to only display 5 images in five columns and then then start a new row. Does anyone know how i can go about this?

Thanks.

[Weedpacket]

This forum comes with a search engine. Try searching for "display columns".

[Rodney_H_]

EDIT: woops. my bad.. pesky parse erors!!

I think THIS might work:

<?php
// start a counter
$counter = 0;
while($row = mysql_fetch_row($result)) {
	$id = $row[0];
	$photo = $row[1];
	$description = $row[2];
	$postdate = $row[3];

// if the remainder of counter divided by five is 0, add a new row:
if ($counter % 5 == 0) {
echo '</tr>' . "\n" . '<tr>' . "\n";
}

?>
<td valign="middle" id="cell_thumbs"><a href="viewPhoto.php?id=<?php echo "$id"; ?>"><img src="<?php echo "$photo"; ?>" alt="" width="133" height="100" border="0" class="thumbs"></a></td>
<?php
// increment counter by 1 after each column
$counter++;
}
?>

[lifeasalounge]

Worked perfectly. Thanks Rodney.