"; header('Content-Type: text/html; charset=tis-620'); include_once('db_config.php'); mysqli_query($con,"TRUNCATE TABLE tmpsp6"); mysqli_query($con,"insert into tmpsp6 (SELECT * FROM $_data where kd_code 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 tmpsp6,$_sch WHERE kd_sch=scode and kd_code like ('bk%') GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC limit 0,5"; $result=mysqli_query($con,$sql); echo << TH; $row=1; while ($db=mysqli_fetch_array($result)) { $total=$db[go]+$db[sv]+$db[bn]; echo << TB; $row++ ; } echo <<<< ดูเหรียญทุก รร.>> TF; mysqli_close($con); ?>

ที่	คลิกเลือกโรงเรียน				รวม
$row	$db[sname]	$db[go]	$db[sv]	$db[bn]	$total