[RESOLVED] Images in horizontal rows

[mrbill501]

Hi
Im trying to display a bunch of images from a database in horizontal rows, 3 thumbnail images in each row and I cant for the life of me figure it out.
My php is:

$query= "SELECT * FROM tbl_images WHERE log_name='{$_SESSION['logname']}' ORDER BY 'image_name' AND 'gallery_id'";
		$result = mysql_query($query) or die (mysql_error());
		while ($row = mysql_fetch_array($result)){
		extract($row);

echo "<tr bgcolor='#3366FF'> 
    <td> <div align='center'><font color='#FFFFFF'><font face='Arial, Helvetica, sans-serif'><font color='#FFFFFF'>$image_title</font></font></font></div></td>
  </tr>
  <tr> 
    <td><div align='center'><font color='#FFFFFF'><font face='Arial, Helvetica, sans-serif'><img src='getthumb.php3?image_id=$image_id'></font></font></div></td>
  </tr>
  <tr bgcolor='#0099CC'> 
    <td> 
      <div align='center'><font color='#FFFFFF'><font face='Arial, Helvetica, sans-serif'>$log_name</font></font></div></td>
  </tr>";
 }
?>

This displays the images but all in a vertical line. Any pointers would be great.
Thanks

[Houdini]

$result = mysql_query($query) or die (mysql_error());
$count=1;
while ($row = mysql_fetch_array($result)){ 
    if($count %3){
//print the row with a <br /> or </tr>
//increment the $count
    $count++;
    }
     else{
//print the row without the <br /> or </tr>
//increment the $count
    $count++;
    }      

}
echo "</table>";// if using a table
?>

[mrbill501]

Thanks man. You are a hero!

[mrbill501]

Right, at the moment I can get the image titles displayed in columns with no problem. What I need is ideally 3 columns with each have 3 rows in, one with the image title, one with the thumbnail and one with the user name of the person whose picture it is.
Does anyone know how to get this kind of display to work? I'm stumped.

		$query= "SELECT * FROM tbl_images WHERE log_name='{$_SESSION['logname']}' ORDER BY 'image_name' AND 'gallery_id'";
		$columns = 3;
$result = mysql_query($query);

$num_rows = mysql_num_rows($result);
echo "<TABLE  WIDTH='740' BORDER=\"0\">\n";

for($i = 0; $i < $num_rows; $i++) {
    $row = mysql_fetch_array($result);
    if($i % $columns == 0) {
               echo "<TR>\n";
    }
    echo "<TD align='center' bgcolor='#3366FF'><font face='Arial, Helvetica, sans-serif'>" . $row['image_title'] . "</font></TD>\n";
    echo "<TD><font face='Arial, Helvetica, sans-serif'>" . $row['image_id'] . "</font></TD>\n";
    if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) {
              echo "</TR>\n";
    }
}
echo "</TABLE>\n";

[Weedpacket]

Die <font> tags! Why won't you die?!

Anyway. Consider using a single <div> tag to hold those three bits; then the <div> tags can go in rows as normal.

You may want to consider some of the ideas in this thread (among others in these forums).

[mrbill501]

Ok that makes sense. I'm a bit slow on this and I've drank a stupid amount of coffee so I'm having trouble thinking this through. Do you mean something like:

echo "<TABLE  WIDTH='740' BORDER=\"0\">\n";
for($i = 0; $i < $num_rows; $i++) {
    $row = mysql_fetch_array($result);
    if($i % $columns == 0) {

    echo "<TR>\n";
}
echo "<div>";
echo "<tr><TD align='center' bgcolor='#3366FF'><font face='Arial, Helvetica, sans-serif' color='#FFFFFF'>" . $row['image_title'] . "</font></TD></tr>";
    echo "<tr><TD align='center' bgcolor='#33CCFF'><font face='Arial, Helvetica, sans-serif' color='#FFFFFF'>" . $row['image_id'] . "</font></TD></tr>";
echo "<tr><TD align='center' bgcolor='#3366FF'><font face='Arial, Helvetica, sans-serif' color='#FFFFFF'>" . $row['log_name'] . "</font></TD>";
echo "</div>";
if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) {
		echo "</TR>\n";		
}
}
echo "</TABLE>\n";

This is returning all the results one on top of eachother rather than in the 3 columns. Sorry if I'm a bit slow, I'm pretty new to this still.