03-13-2014, 12:44 AM
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?
<? $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?