echo ""; //include('header.php'); header('Content-Type: text/html; charset=tis-620'); include_once('db_config.php'); mysqli_query($con,"TRUNCATE TABLE tmpsp2"); mysqli_query($con,"insert into tmpsp2 (SELECT * FROM $_data where kd_code not like ('bk%') group by kd_sch,kd_code,g,s,b)"); $sql="SELECT kd_code, kd_sch,sname,scode,sum(g) AS go,sum(s) AS sv,sum(b) AS bn FROM tmpsp2,$_sch WHERE kd_sch=scode and kd_code not like ('bk%') GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC limit 0,10"; $result=mysqli_query($con,$sql); echo "
ที่ | คลิกเลือกโรงเรียน | รวม | |||
$row | $db[sname] | $db[go] | $db[sv] | $db[bn] | $total |