[rgEffects]

There may be a couple of thousand photos eventually. The maximum length of a slide show is 15 slides. This is to limit loading times. When an image is uploaded it is given an ID and a description. One table contains all of the images.

A user can then go into the slide show creation page and assign up to 15 images to a slideshow. They appear in the order selected. When the slideshow script runs into a null it loops to the first slide. You could even have only one slide in a slide show.

I am trying to avoid having image names in two tables. I think the easiest thing to do is to simply create a table for each slide show that contains links to the slide id's.

If I were to redo the slide show creation form to insert image names instead of image id's then getting the slide show to populate would be easier but I'd loose the descriptions and other info from the images entered when the images are uploaded.

This should be simple. Take a look at a list of values, the image id's and call up all of the information for that ID. I do this kind of stuff with lots of other tables, this one just has me stumped. It should be really simple to look at a the slide show table $row_gallery[slide1] and call up the image name and all of the other data from the imageID stored in the slide1 column.