| $strViews: | ";
stats("$phpAds_tbl_adviews");
print "| $strClicks: | ";
stats("$phpAds_tbl_adclicks");
?>
$strTopTenHosts: | ";
$result = db_query("
SELECT
*,
count(*) as qnt
FROM
$phpAds_tbl_adviews
WHERE
bannerID = $GLOBALS[bannerID]
AND DATE_FORMAT(t_stamp, '$GLOBALS[date_format]') = '$GLOBALS[day]'
GROUP BY
host
ORDER BY
qnt DESC
LIMIT 10
") or mysql_die();
$i = 0;
while ($row = mysql_fetch_array($result))
{
$bgcolor="#F7F7F7";
$i % 2 ? 0: $bgcolor= "#ECECFF";
$i++;
?>
|
|
|
|
" height="11">
" height="11">