include_once('db_config.php');
$sql="select *,sum(g) as gd,sum(s) as sv,sum(b) as bn from $_data
where (g>0 or s>0 or b>0) group by kd_std
order by gd desc,sv desc,bn desc limit 0,5";
$result=mysql_query($sql);
echo "
|
|
|
¹Ñ¡¡ÕÌÒàËÃÕÂÃÒ§ÇÑÅÊÙ§ÊØ´ |
";
while ($db=mysql_fetch_array($result)) {
$sql1="select scode,sname from $_sch where scode='$db[kd_sch]' ";
$result1=mysql_query($sql1);
$db1=mysql_fetch_array($result1);
if ($db[gd]>0) { $gd=$db[gd]; } else { $gd='-'; }
if ($db[sv]>0) { $sv=$db[sv]; } else { $sv='-'; }
if ($db[bn]>0) { $bn=$db[bn]; } else { $bn='-'; }
echo "
$gd |
$sv |
$bn |
|
$db[kd_std]
ÃÃ.$db1[sname] |
";
}
echo "
";
?>