I am building a photo album webpage and am not sure exactly how I
should organize the database. Here's where Im at so far...
I have one table called 'images' which contains the columns
'id','albumID', 'url', 'title', and 'description'.
Then another table called 'albums' which contains the columns 'id' and
'name'.
The part where I am having the trouble is the 'images.albumID' column.
Some photos can be apart of mutliple albums, so should the 'albumID'
column be an array type?
Does anyone have any experience with something like this or know of a
better way to do this??? -Nick