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.