OK, so I figure that may have been a weak question. I've had some advice on another forum to suggest that:
1) I use filenames, not BLOBs
2) I use seperate tables
I want the database to allow two main things -
Specifying which photos should go into three different portfolio galleries on the site, and,
Displaying a unique client's photos (and only their photos!) to them when they log in.
I've spent the afternoon considering how I should therefore design the database and I think I need three tables, like this:
*These columns will be TRUE/FALSE to declare whether the images in them should go into the respective galleries. I've come up with this as any one photo could be displayed in upto three galleries (a client, the homepage, wedding portfolio OR portrait portfolio).
Could anyone give me feedback on this? Being so inexperienced, it's hard to draw conclusions from other peoples questions