Hi there,
I am developing a database for photo gallery and need your help into that. As of now I am storing all images against the album name in my database with some separator. I am able to get and push data perfectly but what is disturbing is that I am not sure if I am using the database in the approved manner. It will be a gr8 favor to me if someone can tell me how to design the following table in a better way.
UId albumName imgName
1 album one a.jpg/b.jpg/c.jpg/…nth.jpg
1 album two one.jpg/two.jpg/…nth.jpg
2 ----------- --------------------------------------
Why i am hesitating in going with the same structure of the table is becasue if someone wants to delete only 1 picture out of his collection it will be a trickky part of maniputaing strings.
Hope that i have mentioned everything needed. Please let me know if you need any other input from me in resolving my issue.
Thnx.
Jatin