"; include('header.php'); header('Content-Type: text/html; charset=tis-620'); include_once('db_config.php'); mysqli_query($con,"TRUNCATE TABLE tmpsp1"); mysqli_query($con,"insert into tmpsp1 (SELECT * FROM $_data 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 tmpsp1,$_sch WHERE kd_sch=scode GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC"; $result=mysqli_query($con,$sql); echo "

สรุปเหรียญ $_title "; $row=1; $tg=0; $ts=0; $tb=0; while ($db=mysqli_fetch_array($result)) { $total=$db[go]+$db[sv]+$db[bn]; echo ""; $row++ ; $tg+=$db[go]; $ts+=$db[sv]; $tb+=$db[bn]; } $tt=$tg+$ts+$tb ; echo "
ที่ คลิกเลือกโรงเรียน ทอง เงิน ทองแดง รวม
$row $db[sname] $db[go]$db[sv] $db[bn]$total
รวม $tg $ts $tb $tt
"; mysqli_close($con); include("footer.php"); ?>