Image Gallery Question

[dcraven]

Hello. I have a question, since I'm fairly new at PHP.

I am setting up an image archive using MYSQL. I link the images by putting the HTML link to the images in a text field. Other fields include details about the photo (date, location, etc.) My goal is to have the PHP use these fields to select the photos, so that the user can, for example, see all photos from the 1960's.

It works up to a point. I can have the PHP insert the photos by inserting the links as variables. What I would like to do though is set up the photos so that they are arranged attractively on the page. What code would do this:

"Take the photos which match the query constraints and arrange them in a table."

I would like the result to look like this:

PIC1 PIC2 PIC3 PIC4
PIC5 PIC6 PIC7 PIC8.

This is what I am getting so far:

PIC1
PIC2
PIC3
PIC4

I can post the code I'm using, but I thought I'd start by asking: is this the most efficient way to do what I want to do? Is there a better way to create a fully searchable image gallery?

Thanks!

Doug

[maxpup979]

there are numerous image gallaries in the code library that do just what you are looking for. However, doing the display bit is easy. Just put the images in a table 4 cells wide. To do this, use something along these lines:

print "<table><tr>";
for($x=0;$x<count($results);$x++){
  if($x%4==0){
    #close the row, open a new one
    print "</tr><tr>";
  }
  print "<td>".$assortedinfo here."</td>";
}
print "</tr></table>"

I think that should do the trick