Database Structure

Anon

Hello:

I have a general question related to database structuring. I am going to be creating some dynamic content with PHP out of MySQL. What would be the most efficient way to structure my tables in order to accomplish this task?

Job_Number - The job number will be the identifier for everything below.
Group - Each Header and Topic values will be assigned to a group, there will be a total of 4 groups.
So with that described it will look like the following:

0011 (Job-Number)
Group 1
Header 1
Topic 1
Topic 2
Topic 3
Group 2
Header 2
Topic 1
Topic 2
Topic 4
etc...

Some groups my have more than one Header and Topic pair.

Thanks,
Troy

Anon

You will need more than one table to do this right.

A groups table, a topics table and perhaps a header table. You may wish to study database normalization a bit before diving in, if you want it done right.

Anon

you'll need multiple tables to keep things straight.

A good intro to database normalization is Jay Greenspan's article 'Your First Database' at Webmonkey...

http://hotwired.lycos.com/webmonkey/99/13/index0a.html?tw=backend

Anon

Thanks for all the help!
After some research I think I have a better understanding of table structures and such.

I posted a new thread on doing an insert with multiple tables that I do need some help with if anyone has some time to help.

Thanks,
Troy