View Single Post
  #5  
Old 04-10-2011, 12:35 AM
Kaeliah's Avatar
Kaeliah Kaeliah is offline
Premium Member
 
Join Date: Sep 2010
Location: Pennsylvania, United States
Posts: 485
Gender: Female
Credits: 31,863
Kaeliah will become famous soon enough
Send a message via AIM to Kaeliah Send a message via MSN to Kaeliah
Default

Yes, I agree.

SELECT theme, COUNT(uid) FROM ".$GLOBALS['prefix']."users GROUP BY theme ORDER BY COUNT(uid) DESC LIMIT 10

I managed to write that statement after some research. XD Took a few tries to get it right though. It's purpose is to count all the users using a particular theme, for ever theme at least 1 user is using. x.x and also select the theme name.
__________________
[My Shop] ♥ [My Blog] ♥ [Subscribe] ♥ [My Mods] ♥ [Mod TOS]
Reply With Quote