Link to home
Start Free TrialLog in
Avatar of shmulik15
shmulik15

asked on

Creating a tagging system

Hi there,

I need some help planning and executing a content tagging system (such as the one Flickr has to tag pictures). I want to know what is the correct way to design the database in the best optimized way to have tags stored at and related to the content they wrere `tagged` to.
I need the tags to be used for pictures, blog posts and some more extra content.
Also, I don't have any idea how to make popular tags be bigger and vice versa

Please notice - I don't want any ready code or examples, just theory guide lines.

P.S. I use ASP and Access database.

Thanks :-)
ASKER CERTIFIED SOLUTION
Avatar of strickdd
strickdd
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shmulik15
shmulik15

ASKER

Thanks !

As for my second question - How do I make display of "popular tags", the popular the bigger etc?
Make the table like this instead:

Tags
   TagID
   Description
   Populate (bit)

Then in your code determine if it is popular and add a style around it.
Your popular field gave me an idea, I'll add something that counts the tags every 24 hours and rate them.

Your help is much appreciated.
Thanks again.