[SOLVED] More Photo Gallery Problems

[camdes]

After much research and hair pulling I have managed to get my photos uploaded, resized and have created thumbnails which are stored in a separate directory. All the required information about the uploaded files including the paths are stored in a Mysql database.

 

My problem now is that when I retrieve all the thumbnails in a category I can only display them in a single column. I would like to display them in 4 or 6 columns with as many rows as required, can someone help a newbie please.

[jvrothjr]

Your could use tables.

 

Loop thru that data and every 4th or 6th start another row

 

[camdes]

Worked at it another way but still having problems. The following code is not the one I will be finally using but I am trying to do one step at a time.

 

The table I am showing should have a thumbnail in one column and a link path in another. This is just to show that the SELECT statement is working. The first column does not show the thumbnails and does not even pick up the path while the second column does and the links work. Can anyone help, I seem to have been at this for ever.

 

<?php
$SQL = 'SELECT photo_id, photo_thumbnail FROM gallery_photos ';

// execute SQL statement 
$ret = mysql_db_query($dbname,$SQL,$link); 
$numrows = mysql_num_rows($ret);

if (!$ret) { echo( mysql_error()); } 
else { 
while ($img = mysql_fetch_array($ret)) { 
$id = $img[photo_id];
$thumbnail = $img[photo_thumbnail];
$i = $numrows;

echo ("<TR>");
echo ('<td> <img src=<?php echo ("$thumbnail");?>> </td>');
echo ("<TD><a href=\"$thumbnail\" target=_blank>$thumbnail</a></TD>\n"); 

echo ("</TR>"); 
}
echo ("</TABLE>");
}

?>