Myujth

I am trying to order in while from higger count of clicks to the lower and I am a bit of lost so I decided to ask the qustion here.

My code :

$stmt = $db->query("SELECT DISTINCT `country` FROM `entries` ORDER by `id` ASC");
if ($stmt->rowCount() > 0) {
 while ($row = $stmt->fetch()) 
 $clicks = $db->query("SELECT `id` FROM `entries` WHERE `country` LIKE '$row['country']'")->rowCount();
 $conversations = $db->query("SELECT `id` FROM `conversations` WHERE `country` LIKE '$row['country']' AND `link_id` = '$id'")->rowCount();
 

I want the foreach give me results from highest count of $clicks to the lowest.

Any ideas what can I do ?

You can do this query entirely in SQL with something like this (depending on SQL dialect):

$countries = $db->query("SELECT `country`, count(1) AS clicks FROM `entries` GROUP BY `country` ORDER BY clicks DESC");
foreach ($countries as $country) 
 echo "$country['country'] has $country['clicks'] clicks. ";

put number of clicks in an array as below :

 $clicks = $db->query("SELECT `id` FROM `entries` WHERE `country` LIKE '$row['country']'")->rowCount();

then you can simply sort the array by rsort php function as below :

echo rsort($clicks);