Статистика системы BannerHost. |
|
$qs="SELECT
sum(show_on_acc) as show_count,stat_date,sum(click_on_acc) as click_count FROM
acc_clock_stat WHERE TO_DAYS(stat_date)>=(TO_DAYS(CURDATE())-1) group by stat_date order by stat_date DESC";
$res=mysql_query($qs);
#echo "$qs ";
$row=mysql_fetch_array($res);
$ctr=($row[0]>0)?($row[2]*100/$row[0]):0;
$sctr=number_format($ctr,2);
echo "показано сегодня / ctr | .......... | $row[0] / $sctr | ";
$row=mysql_fetch_array($res);
$ctr=($row[0]>0)?($row[2]*100/$row[0]):0;
$sctr=number_format($ctr,2);
echo "показано вчера / ctr | .......... | $row[0] / $sctr | ";
?>
|
|
|