#FlagCountry name Users"; $query = dbquery("SELECT DISTINCT user_country, COUNT(*) FROM ".DB_USERS." WHERE user_country IS NOT NULL GROUP BY user_country ORDER BY COUNT(*) DESC "); $rows = dbrows($query); $i = 1; $wynik =""; if ($rows) { while ($data = dbarray($query)) { $num = dbcount("(user_country)", DB_USERS, "user_country='".$data['user_country']."'"); $wynik .= " ".$i++." ".$locale['uf_country_'.strtolower($data['user_country']).'']." ($num)"; } } else if ($rows = NULL) { $wynik =""; } echo $wynik; echo ""; ?>