Dhuan
03-28-2009, 09:41 PM
Okay, this is the table users:
user_id | password | album
each user can have his own album, where he can put as many photos (links to images) as he wants. now, what would be the best way to store their album photos? should i create i new table named album or should I store all the photo links in a single record of the 'album' colunm?
Thing is, if i store all the links to the images in a record, then I wont be able to edit/erase one without erasing the whole record... right?
user_id | password | album
each user can have his own album, where he can put as many photos (links to images) as he wants. now, what would be the best way to store their album photos? should i create i new table named album or should I store all the photo links in a single record of the 'album' colunm?
Thing is, if i store all the links to the images in a record, then I wont be able to edit/erase one without erasing the whole record... right?