I'm an building a directory site based on a CMS system. One thing i am keen to implement is tagging. I have a couple of questions about the best way to implement this. The site to begin with will be a directory of drinks, so let me give you a sample page:
You can see the tagging guidlines i'm trying to follow here: http://microformats.org/wiki/rel-tag
This page would be produced from a database and all the links you can see are tags. My first question is how best to store these tags in a database? Do i put them all in one column and spearate them by a ',' or do i use a space, or do i have them in a separate table etc. Also how should i implement and store tags with more than one word like "Jack Daniels"?
Secondly as you can see in the above link tags should be specified in the URL like: www.mysite.com/tags/mango. How can i do this in ASP when my application is database driven. Surely i don't have to create a folder with a separate page with www.mysite.com/tags for every tag? How is this done?