"; //include('header.php'); header('Content-Type: text/html; charset=tis-620'); include_once('db_config.php'); mysql_query("TRUNCATE TABLE tmpsp2"); mysql_query("insert into tmpsp2 (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 tmpsp2,$_sch WHERE kd_sch=scode GROUP BY scode ORDER BY go DESC,sv DESC,bn DESC limit 0,12"; $result=mysql_query($sql); echo "
ÊÃØ»àËÃÕ­ $_title
12 Íѹ´Ñºáá
<< ´ÙàËÃÕ­·Ø¡ ÃÃ.>>"; echo ""; echo ""; $row=1; while ($db=mysql_fetch_array($result)) { $total=$db[go]+$db[sv]+$db[bn]; echo ""; $row++ ; } echo "
·Õè ¤ÅÔ¡àÅ×Í¡âçàÃÕ¹ ·Í§ à§Ô¹ ·Í§á´§ ÃÇÁ
$row $db[sname] $db[go]$db[sv] $db[bn]$total
<< ´ÙàËÃÕ­·Ø¡ ÃÃ.>>
"; ?>