order by count and tag

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FrEaKmAn
    New Member
    • Aug 2007
    • 46

    order by count and tag

    Hello

    I have sql statement:

    Code:
    SELECT count(id) FROM artists_tags GROUP BY tag ORDER BY count(id) DESC, tag ASC
    I want to create simple tag cloud, so I want to order by the amount, count some tag appears and then sorted that tags by name ASC. As I know, my code doesn't do this as it sorted tags by name only where count results repeat...

    I could also use simple sort option with php, but for some reason it has problems with special symbols...
  • rohypnol
    New Member
    • Dec 2007
    • 54

    #2
    What columns does the artists_tags table have? What information does it contain?

    Comment

    Working...