Date: 02/26/07 (PHP Community)    Keywords: database

As per my previous post I’m making a very simple blog. I'd like to include tags as a feature.
I'm having trouble understanding the logic behind...

The way I see it I'll need 2 or more tables in my database. One to handle the posts and one to handle the tags. In the post table I’d have an ID, subject, body, time, who posted it. For the tags table I’d have an ID, and tag field. Am I correct so far?
I lose it at this point because now, what if someone tags with 'My Vacation to Mexico' and not Vacation, Mexico, Fun. The tag field in my tags table will be unable to sort by Mexico in the first example, or I'll get a bunch of crap data and be able to sort by the word My.

Thoughts Ideas?


Thanks.

Source: http://community.livejournal.com/php/546150.html