Table Columns and Counting

[MartynLearnsPHP]

Hi,

 

I am trying to make a list of all countries listed in a database and the number of times they appear. But I am clearly doing something wrong as I am not able to list out the number of times that they appear.

 

This is what I have got so far:

<h4>Countries</h4>
<table><col width='150px'><col width='150px'>
<tr>
	<th>
		Country
	</th>
	<th>
		Number of Occurences
	</th>
</tr>
<?php
$location = DB::getInstance()->query("SELECT country, COUNT(country) as countCountry FROM users GROUP BY country ORDER BY count DESC");
foreach ($location->results() as $locations)
{
	echo "<tr><td>";
	echo $locations->country;
	echo "</td><td>";
	echo $locations->countCountry;
	echo "</td></tr>";
}
?>
</table>

Can anyone point me in the right direction?

[Ch0cu3r]

ORDER BY count   should be    ORDER BY countCountry

[Barand]

Try

$location = DB::getInstance()->query("SELECT country, COUNT(country) as countCountry FROM users GROUP BY country ORDER BY count DESC");
while ($locations = $location->fetch_object())
{
    echo "<tr><td>";
    echo $locations->country;
    echo "</td><td>";
    echo $locations->countCountry;
    echo "</td></tr>";
}

edit : Plus what Ch0cU3r said.

Edited November 30, 2014 by Barand

[MartynLearnsPHP]

Fantastic. Amending my ORDER BY has resolved my problem.

 

Thanks you guys. Your help is very much appreciated!