"; include('db_config.php'); //$scid='sk1'; mysql_query("TRUNCATE TABLE tmpkap6"); mysql_query("insert into tmpkap6 (SELECT * FROM $_data group by kd_sch,kd_code,g,s,b,kd_school)"); $sql="select *,sum(g) as gld from $_data where kd_sch='$scid' group by kd_school order by gld desc"; $result=mysql_query($sql); echo "สรุปเหรียญทอง แยกตามกลุ่มสาระ รร.ในสังกัด สพป.ศก.1 << ดูทุกโรงเรียน >> "; $row=1; $s1=$s2=$s3=$s4=$s5=$s6=$s7=$s8=$s9=$s10=$s11=$s12=$s13=$ts=0; while ($db=mysql_fetch_array($result)) { $sql1="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='15' and g>0"; /* ปฐมวัย*/ $result1=mysql_query($sql1); $s1=mysql_num_rows($result1); $sql2="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='01' and g>0"; /* ไทย */ $result2=mysql_query($sql2); $s2=mysql_num_rows($result2); $sql3="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='02' and g>0"; /* คณิต */ $result3=mysql_query($sql3); $s3=mysql_num_rows($result3); $sql4="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd in ('03','04') and g>0"; /* วิทย์+นักบินน้อย */ $result4=mysql_query($sql4); $s4=mysql_num_rows($result4); $sql5="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='05' and g>0"; /* สังคม */ $result5=mysql_query($sql5); $s5=mysql_num_rows($result5); $sql6="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd in ('07','08','09') and g>0"; /* ศิลปะ */ $result6=mysql_query($sql6); $s6=mysql_num_rows($result6); $sql7="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd in ('12','14') and g>0"; /* การงาน+เทคโนฯ */ $result7=mysql_query($sql7); $s7=mysql_num_rows($result7); $sql8="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='06' and g>0"; /* สุขศึกษา */ $result8=mysql_query($sql8); $s8=mysql_num_rows($result8); $sql9="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='10' and g>0"; /* ต่างประเทศ */ $result9=mysql_query($sql9); $s9=mysql_num_rows($result9); $sql10="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='11' and g>0"; /* พัฒนาผู้เรียน */ $result10=mysql_query($sql10); $s10=mysql_num_rows($result10); $sql11="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='13' and g>0"; /* หุ่นยนต์ */ $result11=mysql_query($sql11); $s11=mysql_num_rows($result11); $sql12="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd='20' and g>0"; /* อีสาน */ $result12=mysql_query($sql12); $s12=mysql_num_rows($result12); $sql13="select * from tmpkap6,$_act WHERE kd_code=kp_code and kd_sch='$scid' and kd_school='$db[kd_school]' and kp_cd in ('16','17','18','19') and g>0"; /* เรียนร่วม */ $result13=mysql_query($sql13); $s13=mysql_num_rows($result13); $ts=$s1+$s2+$s3+$s4+$s5+$s6+$s7+$s8+$s9+$s10+$s11+$s12+$s13; if ($ts>0) { $tot=$ts; } else { $tot='-'; } if ($s1==0) { $s1='-'; } if ($s2==0) { $s2='-'; } if ($s3==0) { $s3='-'; } if ($s4==0) { $s4='-'; } if ($s5==0) { $s5='-'; } if ($s6==0) { $s6='-'; } if ($s7==0) { $s7='-'; } if ($s8==0) { $s8='-'; } if ($s9==0) { $s9='-'; } if ($s10==0) { $s10='-'; } if ($s11==0) { $s11='-'; } if ($s12==0) { $s12='-'; } if ($s13==0) { $s13='-'; } $res=$row%2; if ($res==0) { $cl='#ebd7ff'; } else { $cl='#f3e8ff'; } $school=substr($db[kd_school],0,30); echo ""; $t1+=$s1; $t2+=$s2; $t3+=$s3; $t4+=$s4; $t5+=$s5; $t6+=$s6; $t7+=$s7; $t8+=$s8; $t9+=$s9; $t10+=$s10; $t11+=$s11; $t12+=$s12; $t13+=$s13; $row++ ; } $tt=$t1+$t2+$t3+$t4+$t5+$t6+$t7+$t8+$t9+$t10+$t11+$t12+$t13; echo "

ที่

โรงเรียน

จำนวนเหรียญรางวัล แยกกลุ่มสาระการเรียนรู้ (เฉพาะเหรียญทอง)

รวม
283

ปฐมวัย

ไทย

คณิต

วิทย์

สังคม

ศิลปะ

การงาน

พละ