Why do you want a one column for one image. can you not have it like that? Image table image_id | image_name | path | status/inuse | userid | 1 | image 1 | images/uploaded/| 1 | registered_user_id image_id can be auto increment. hope it what you want. --- In php-objects@xxxxxxxxxxxxxxx, "arvindsri123" <arvindsri123@...> wrote: > > Hi, > > Thanks for reply, If i am using separate table for images, how i can create n number of columns in php through froms when user will submit? > > Thanks, > Arshi > > > --- In php-objects@xxxxxxxxxxxxxxx, Richard Damon <richard@> wrote: > > > > On Sat, 11 Jul 2009 16:50:48 -0000, "arvindsri123" > > <arvindsri123@> wrote: > > > > >Hi, > > > > > >Thanks for reply... > > > > > >When i will make column in table for images, normally i will make 3 column for 3 images but when i will add more images field in forms how i can create new column for new images, is there anything that column can create automatically when i upload more than 3 images? b-cz user can upload any number of images. > > > > > >I am giving link again here > > >http://www.wowapic.com/add_image.php > > > > > >please click on "Upload more pictures? [Click here]" > > > > > >Thanks, > > >Arshi > > > > > > > Having a fixed number of fields to handle a varialble number of > > entries shows a problem with database normalization. > > > > Instead of having n columns for images, you should have a seperate > > table for images, with each record of images linking back with the > > primary key of the original record. > > > > Richard Damon > > >