Hello
I have sql statement:
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...
I have sql statement:
Code:
SELECT count(id) FROM artists_tags GROUP BY tag ORDER BY count(id) DESC, tag ASC
I could also use simple sort option with php, but for some reason it has problems with special symbols...
Comment