";
include('db_config.php');
if ($gr=='07') {
$sql="select * from $_act where kp_cd in ('07','08','09') order by kp_cd,kp_id";
} elseif ($gr=='16') {
$sql="select * from $_act where kp_cd in ('16','17','18','19') order by kp_cd,kp_id";
} else {
$sql="select * from $_act where kp_cd='$gr' order by kp_id";
}
$result=mysql_query($sql);
echo "
จำนวนนักเรียนเข้าแข่งขัน $_title
กิจกรรม (ช่วงชั้น)
รร.สมัคร
นักเรียน(คน)
";
$rw=1; $tsch=0; $tstd=0;
while ($db=mysql_fetch_array($result)) {
$grp=$db[kp_grp];
$sql0="select count(kd_code) as nstd from $_data where kd_code='$db[kp_id]' ";
$result0=mysql_query($sql0);
$db0=mysql_fetch_array($result0);
$sql1="select kd_sch,kd_code from $_data where kd_code='$db[kp_id]' group by kd_sch ";
$result1=mysql_query($sql1);
$nsch=mysql_num_rows($result1);
if (empty($nsch)) {
$sch='-';
} else {
$sch=$nsch;
}
if (empty($db0[nstd])) {
$std='-';
} else {
$std=$db0[nstd];
}
echo "