MySQL Table design

programming
1

Hi there,

I am trying to create a photo gallery using MySQL and PHP.

I want to know your opinions on this design issue:

I have a table called ‘gallery’. This contains info on all photo galleries: date, location, etc.

What is most efficient:

A) Create a separate table per 'Gallery’ record to hold all ‘Photos’ in each gallery.

or

B) Create 1 big Table name ‘Photo’s’ with all photos, and a ‘**Gallery’ ** key in ‘Photo’s’ to reference the ‘Gallery’ table.

Opinions ???

wDigital