";
include('db_config.php');
$sql="select * from $_act group by kp_type";
$result=mysqli_query($con,$sql);
echo "สรุปการรับสมัครแข่งขัน $_title
| ประเภทกีฬา |
แข่งขัน
ทั้งหมด | ประเภท
ที่สมัครแล้ว |
จำนวน
นักกีฬา |
ส่งออก
Excel |
";
$rw=1; $tact=0; $tstd=0;
while ($db=mysqli_fetch_array($result)) {
$cd=$db[kp_type];
$sql0="select count(*) as nstd from $_data where kd_code like '$cd%' ";
$result0=mysqli_query($con,$sql0);
$db0=mysqli_fetch_array($result0);
$sql1="select count(kp_act) as nact from $_act where kp_type like '$cd%' ";
$result1=mysqli_query($con,$sql1);
$db1=mysqli_fetch_array($result1);
$sql2="select kd_code from $_data where kd_code like '$cd%' group by kd_code";
$result2=mysqli_query($con,$sql2);
$db2=mysqli_fetch_array($result2);
$nreg=mysqli_num_rows($result2);
if (empty($db1[nact])) {
$act='-';
} else {
$act=$db1[nact];
}
if (empty($db0[nstd])) {
$std='-';
} else {
$std=$db0[nstd];
}
if (empty($nreg)) {
$reg='-';
} else {
$reg=$nreg;
}
$sstd=number_format($std,2,'.',',');
echo "
| $rw.$db[kp_grp] |
$act |
$reg |
$std |
ส่ง Excel |
";
$rw++; $tact+=$db1[nact]; $tstd+=$db0[nstd]; $treg+=$nreg;
}
$pc=number_format($treg*100/$tact,2,'.',',');
$sstd=number_format($tstd,0,'.',',');
echo "| รวม |
$tact | $treg |
$sstd | $pc% |
";
mysql_close($con);
//include("footer.php");
?>