[RESOLVED] Finding 10 most popular entries in a table?

[wwwfilmfilercom]

I'd like to add a feature to my site whereby whenever someone clicks on an item it will add that items tags to a table. Then, I can look into this table and find out the top 10 entries. Make sense?

The bit I'm stuck on is how to find just the top 10 UNIQUE entries rather than just the top 10 entries.. How can I find it out?

Thanks;)

[penagate]

What is your table structure like?

[wwwfilmfilercom]

table Tags
tagID - int
tagName - string


That's it. So when an item is clicked, I just get it's tags and add each one seperately to the table..

[penagate]

Why not:

tagID
tagName
tagCount

Then, when you click an item, check to see if it is present in the table; if it is, increment its count field; if it's not, add it.

Or even better, add the tags when you add the item, so you don't have to check whether it exists or not.

[wwwfilmfilercom]

Ah, much better idea. Thanks ;)