Image category and subcategory of images for slideshow

PHP
1

Hi All,

Hopefully someone can help with the following.

I have an image gallery that dynamically displays thumbnails of images assigned to a category eg furniture/lighting etc. When the user selects a thumbnail the original image and details is displayed in a new page. So far nothing new here and all works well.

I now need to be able to upload a series of images for each item. When a category is selected I need the thumbnails displayed as above but when an thumbnail is selected and the large image is displayed I need to be able to have all related images for that item available. These would be layed out so that a slideshow of the images of the item is available to the user.

Currently, the category and image info is stored in a mysql database (2 tables) and I use php to display the gallery. If someone can suggest how the tables should be set up and how to get the sub items that would be great.

Regards
Stan

2

Ha,

Yep thats about right, simple really :rolleyes:. I still need to work out how to upload the images into the correct tables :shifty: any thoughts on what the script may look like to do that.

But hey, at least I got something to work on, as I say simple really when you got the basic structure so its off to code I go :smiley:

3

This is what I’d do:

ALBUM

id
title

PRODUCT

id
album_id
title

IMAGE

id
product_id
file