+- MN Forum (http://forum.mn-shop.com)
+-- Forum: Products (http://forum.mn-shop.com/forum-products.html)
+--- Forum: Ask a Question (http://forum.mn-shop.com/forum-ask-a-question.html)
+--- Thread: Sidebar exchanges (/thread-sidebar-exchanges.html)
Sidebar exchanges - iutraffic - 03-13-2014
Under photos want to add as the total number exchanges
<? $sql = $db->QueryFetchArray("SELECT COUNT(*) AS total FROM `users`"); echo number_format($sql['total']); ?>
<?
$sql = $db->Query("SELECT a.uid, SUM(a.today_clicks) AS clicks, b.login FROM user_clicks a LEFT JOIN users b ON b.id = a.uid WHERE b.login != '' GROUP BY a.uid ORDER BY clicks DESC LIMIT 3");
if($db->GetNumRows($sql) >= 3)
?>
To change number exchanges where the total flow, what should I do?