multiple tags

[Wolfsoap]

hi.

i have my journal running off an SQL database but I can only have one tag.

The table basically has 4 fields (headline, date, article and tag) and the id. I can only put one thing in the tag field for each article I would like to put more.

I was wondering how would I go about building a system for this?

I could do it by separating tags in the fields with commas and exploding them for multiple one, but there must be a simpler way.

[leatherback]

You'd add 2 tables to your database:

1 lookup table: Tags [id][value]
1 linking table: item to tag: [item_nr][tag_nr]

and you join them through a double join.