Layout of Database

[LindyTaylor]

Hi

I am trying to submit label1, label2, label3, etc.....into a column of a table that controls content for each web page. What I want to do is when someone clicks on any tag that tag queries the DB and pulls to create a list of links for every page that controls that tag. The question is, how can I organize the tables out for the best performance and scalability.

[Irene9001]

Just create tables like below:

labels(labelid, labelname)
labellinks(labelid, linkurl)

labels.labelid will be a primary key. Create an index on labellinks.label.id