How to set up mysql database to hold multiple image path fields
Posted on 2007-11-26
I've currently got a script which uploads one image to my server and stores the path to that image in my database.
However I want the user to be able to upload more than 1 image at a time (probably around 12). Now in php I can easily upload multiple images using a loop, that's not the problem.
My problem is how do I store the paths to all uploaded images in my database?
Would I have to add more path fields? (like path1, path2, path3 etc.)
Currently my image table cosists of ID, Name, Path fields.
Can anyone shed some light on this please? it's been bugging me for too long.