计数后对结果进行排序 PHP

Question

该代码效果很好，但我不知道如何订购它。

示例输出：

点击 3 Mozilla Firefox
点击 2 Google Chrome
点击 4 Internet Explorer
点击 2 Apple Safari
热门歌剧 1

$result = mysql_query("SELECT * FROM WEB_STATS WHERE real_user NOT LIKE 'Bot'");
$duplicates = array();
while($row = mysql_fetch_array($result)) {
    $results = $row['user_browser'];

if (!array_key_exists($results, $duplicates)) {
    $browsersLive[] = $results;
    $duplicates[$results] = 1; ## mark that we've already output this records
    }
    }

foreach($browsersLive as $browserswive){
    $query = "SELECT COUNT(*) FROM WEB_STATS WHERE user_browser = '$browserswive'";
    $result = mysql_query($query) or die("Sorry, didn't work" . mysql_error());
    $browser_count = mysql_result($result, 0);

    if($browserswive == "Mozilla Firefox"){
    echo '<img alt="FireFox" height="32" src="images/fox-icons.png" width="32">Hits '.$browser_count.' '.$browserswive.'<br>';
}
    elseif($browserswive == "Internet Explorer"){
    echo '<img alt="Internet Explore" height="32" src="images/ie-icons.png" width="31">Hits '.$browser_count.' '.$browserswive.'<br>';
}
    elseif($browserswive == "Google Chrome"){
    echo '<img alt="Google Chrome" height="32" src="images/chrome-icons.png" width="32">Hits '.$browser_count.' '.$browserswive.'<br>';
}
    elseif($browserswive == "Apple Safari"){
    echo '<img alt="Apple Safari" height="32" src="images/safari-icons.png" width="32">Hits '.$browser_count.' '.$browserswive.'<br>';
}
    elseif($browserswive == "Opera"){
    echo '<img alt="Opera " height="33" src="images/opera-icons.png" width="33">Hits '.$browser_count.' '.$browserswive.'<br>';
}
}

Answer 1

将 SQL 调整为

SELECT user_browser, COUNT(*) as hits
FROM WEB_STATS 
WHERE real_user!='Bot'      <-- replace the NOT LIKE 'Bot'
GROUP BY user_browser
ORDER BY hits DESC;

您只需要查询一次，然后迭代结果

Answer 2

尝试排序如下：

• SUBSTRING_INDEX(colName,2) --> HITS 2 歌剧 ===>命中 2
• SUBSTRING(,INSTR(' ',colName)) -->点击 2 ==> 2
• 演员（已签名）-->将 2 转换为数字

将它们放在一起

ORDER BY CAST(substring(substring_index(colName,2),INSTR(' ',colName)) AS SIGNED)

这应该可以满足您的要求......