"; include('db_config.php'); mysql_query("TRUNCATE TABLE mt1"); mysql_query("insert into mt1 (SELECT * FROM $_data group by kd_sch,kd_code,g,s,b)"); //if ($grp=='04') { $kg="kp_cd in ('04','05','06')"; } else { $kg="kp_cd like '$grp%' "; } if ($grp=='04') { $kg="kp_cd in ('04','05','06')"; } elseif ($grp=='12') { $kg="kp_cd in ('12','13','14','15')"; } else { $kg="kp_cd like '$grp%' "; } $sql="select * from $_act where $kg order by kp_code"; $result=mysql_query($sql); echo "
สรุปเหรียญรางวัล แยกรายกิจกรรม $_title"; echo ""; echo ""; $rw=1; $tg=0; $ts=0; $ts=0; $ta=0; $total=0; while ($db=mysql_fetch_array($result)) { $sql1="select *,sum(g) as g,sum(s) as s,sum(b) as b from mt1,$_act where kp_code=kd_code and kp_code='$db[kp_code]' group by kp_code "; $result1=mysql_query($sql1); $db1=mysql_fetch_array($result1); $tt=$db1[g]+$db1[s]+$db1[b]; if ($db1[g]==0) { $db1[g]='-'; } if ($db1[s]==0) { $db1[s]='-'; } if ($db1[b]==0) { $db1[b]='-'; } echo ""; $tg+=$db1[g]; $ts+=$db1[s]; $tb+=$db1[b]; $total+=$tt; $rw++; } echo ""; echo "
ที่รหัส กลุ่มสาระกิจกรรม รวม
$rw $db[kp_code]$db[kp_grp] $db[kp_act] $db1[g] $db1[s] $db1[b] $tt
รวม $tg $ts $tb $total
"; ?>