Mysql Query Count

[mart94]

Hi,

Im working on Top5 system, right. So i need help with this part: How to i get top results like, i have in table Country, and i need to get TOP5 of them, i mean like what Country are there most.

Example:

Country

Estonia

Estonia

Estonia

Russia

England

England

Then TOP will be so:

#1 Estonia

#2 England

#3 Russia

 

Hope you all understand and help me

 

All The Best:

Mart

[Mchl]

SELECT country, COUNT(*) AS countryCount FROM tableName GROUP BY Country ORDER BY countryCount DESC LIMIT 5

[mart94]

SELECT country, COUNT(*) AS countryCount FROM tableName GROUP BY Country ORDER BY countryCount DESC LIMIT 5

Hi, thanks for reply but i have still problems.

My code:

$c = mysql_query("SELECT country, COUNT(*) AS countryCount FROM TOP GROUP BY Country ORDER BY countryCount DESC LIMIT 5");
while($topc = mysql_fetch_assoc($c)){
$topcountry = $topc['country'];
echo $topcountry;
}

 

Result is coming out messed up, what im doing wrong?

All The Best:

Mart

[Mchl]

What do you mean by 'messed up' ?