Not sure if this should be posted in php or mysql. I am new to php and mysql and just got started with the codigniter framework. My application basically has a form to add new materials or items. I want to upload images for some of the items. However some of the items are similar and I would like to choose an existing gallery that I already setup. I am not sure how to go about this as far as naming the images, galleries etc. Should I create a seperate table for the Galleries. Another way I was thinking was adding a column to the existing table and representing each gallery by a unique number. Like I said I am fairly new to all this and just looking for a shove in the right direction. I have not yet create tables with foreign indexs but I am sure I will need to do that sooner than later. ANy suggestion would be greatly appreciated. I can figure out how to upload resize and store them. Just trying to figure out which way to get them in the database. For example I was thinking of maybe uploading each gallery to a folder based on the name of the gallery and each image uploaded will be named 01.jp, 02.jpg, etc. This way I could a count on the files in the folder and list each one for every file counted in the folder. Like I said I am open to suggestions I just really need to figure out which way will work best.