Photo Gallery Display

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.

steamPunk

you need to post the code you use to select and display the thumbnails

camdes

Almost Managed it - got the display working to show thumbnails in 4 columns,
unfortunately although I am using virtually the same code to get the
information from the database as I have used on other pages I cannot get my
query to work.
As you will see from the following code I have echoed the $query and the
$res and all I get is $query and $res. Here is my code in the hope someone
can help:

<?php
 //$query = " SELECT photo_id, photo_thumbnail FROM gallery_photos WHERE 
photo_category='$category' order by photo_id desc ";

$query = " SELECT photo_id, photo_thumbnail FROM gallery_photos order by 
photo_id desc ";

$res=mysql_query($query) or die ("Invalid Query:".mysql_error());

echo '$query<BR>';
echo '$res<BR>';

$col=0;
echo '<table>';
while($img=mysql_fetch_array($res)) {
 $thumb = $row[photo_thumbnail];
 $id = $row[photo_id];
    if($col==0) echo '<tr>';
  echo '<td> <img src="$thumb"> </td>';
    $col++;
    if($col==4) {
        echo '</tr>';
        $col=0;
    }
}
if($col!=0) str_repeat('<td></td>', 4 - $col);
echo '</table>';
 ?>

shmoo525

I believe you need to use double quotes to get the variables to display the way you want...

echo "$query<BR>";
echo "$res<BR>";

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.

$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>");
}

?>

dagon

your embedding php in php so

echo ('<td> <img src=<?php echo ("$thumbnail");?>> </td>');

should be

echo ('<td> <img src="'.thumbnail.'"></td>');

camdes

Thank you. Almost got it working now. Got the thumbnails albeit the page is not very nice yet, but I will work on that when I have everything working. I now have the thumbnails linking to the main photo path in the database and the photo is displayed with the caption and some other information I require.

I now wish to add "previous" and "next" links to show other photos without going back to the thumbnails. Can someone help please? Do I need to put things in a form so that I pass the existing photo_id to allow me to select the next.