need help

[skdzines]

Does anyone know how I can dynamically add images from a database but only allow up to 5 thumbnail images in a single row? I can do the query to get the list of images and list them all on the same row or seperate rows doing a while loop. But I don't know how to only list 5 per row then go to the next row.

Any help is greatly appreciated.

Thanks

[planetsim]

Does anyone know how I can dynamically add images from a database

That makes no sense can you please explain a little better

only allow up to 5 thumbnail images in a single row

//query here
$i = 0;
while ($row = mysql_fetch_array($query))
{
    if (($i%5) == 0)
    {
        //new row
    }
    echo $row['img']; //example
    $i++;
}

[skdzines]

Let me try to clarify.

I have the following code that will put all of my thumbnail images into it's own table cell all on the same row.

$sql = "SELECT *
        FROM images WHERE showID = ".$showID.""; 
	$res = mysql_query($sql);
	while($image = mysql_fetch_array($res)) {

   echo ("
        <tr><td><a href='imageDisplay.php?id=".$image['id']."' target='display'><img src='".$image['location']."/thumbs/".$image['pic'].".".$image['ext']."' width='55' height='45' border='0'></a></td>
  </tr>

What I want to do now is only place 5 thumbnail images in one row, then add another five to the next row and so on.

Thanks

[Roger_Ramjet]

Simple really. start a counter. go into your while loop. check the counter. less than 5 = just put thumbnail in cell. counter = 5 start a new row and reset counter. add one at the end of the loop

If you try it and get 4 or 6 in the row then you just have to amend the way you count untill it is 5 in a row

[skdzines]

okay, I can't seem to get it to create a new row and continue going through the loop. this is what I have:

<table align='left' width='100%' border='0' cellspacing='0' cellpadding='0'>
  <tr>"); 

$sql = "SELECT *
    FROM images WHERE showID = ".$showID.""; 
$res = mysql_query($sql);
$i = 0;
while($image = mysql_fetch_array($res)) {
	if($i < 5){
	   echo ("
			<td><a href='imageDisplay.php?id=".$image['id']."' target='display'><img src='".$image['location']."/thumbs/".$image['pic'].".".$image['ext']."' width='55' height='45' border='0'></a></td>
		");
		$i++;
	}
}
	$i = 0;
	echo"</tr><tr>";

echo("
  </tr>
</table>

I don't kinow how to get it to add the new row once it reaches a number greater than 5 and then continue back through the loop. I have tried a number of things and nothing seems to work.

I'm sure it is going to be something really simple but I can't seem to get it.

Thanks for your help.

[Roger_Ramjet]

Good try. You forgot it was an if-else situation:

IF less than 5 images on row, add to row
ELSE start new row first, then show the current image

echo '<table align="left" width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>';

$sql = "SELECT *
    FROM images WHERE showID = $showID";
$res = mysql_query($sql);
$i = 0;
while($image = mysql_fetch_array($res)) {
    if($i < 5){
	   // if less than 5 images in row, show another
       echo '<td><a href="imageDisplay.php?id="'.$image['id'].'" target="display"><img src="'.$image['location'].'"/thumbs"'.$image['pic'].'.'.$image['ext'].'" width="55" height="45" border="0"></a></td>';
    }
    else {
       // otherwise start a new row
       echo '</tr><tr>';
       // reset counter
       $i=0;
       // show first image
       echo '<td><a href="imageDisplay.php?id="'.$image['id'].'" target="display"><img src="'.$image['location'].'"/thumbs"'.$image['pic'].'.'.$image['ext'].'" width="55" height="45" border="0"></a></td>';
    } //-- endif
    // count the image, whether it was a new row or not you count it, so you count it outside the if-else
    $i++;
} //-- wend
echo '</tr></table>';

Now, as my sig says, there could be typos, BUT THERE IS NO LOGIC ERROR

Also:
no need for brackets with the echo
notice my string quoting syntax
since SQL uses single quotes in queries, I use double quotes aroung SQL in my PHP
since HTML uses double quotes in it's syntax, I use single quotes around it in PHP
Just makes it easier to keep it clean