Статистика системы 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 | ";
?>
| |
|
|