Site Stats > Education Analysis"; $green_box_img = "icon_community.gif"; $green_box = "Site Stats"; include "../include/header.php"; $query_month = "SELECT COUNT(*) FROM e_site_stats GROUP BY MONTH(wdate), YEAR(wdate)"; $res_month = mysqli_query($query_month,$connect); $tot_month = mysqli_num_rows($res_month); $visitor_sum = ""; for($vm=0;$vm<$tot_month;$vm++) { $row_month = mysqli_fetch_array($res_month); $visitor_sum = $visitor_sum + $row_month[0]; } $visit_tot = $visitor_sum / $tot_month; $visit_tot = round($visit_tot); $avg_rate_qry = mysqli_query("SELECT sum(pt) as sum,count(*) as total from e_rating;",$connect); $avg_rate_row = mysqli_fetch_array($avg_rate_qry); $class_avg_rate = $avg_rate_row[sum] / $avg_rate_row[total]; $class_avg_rage = round($class_avg_rate,2); ?>

Education Analysis   1. Average visitor per month 2. Average Rate of Classes