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 ""; } echo "

			¹Ñ¡¡ÕÌÒàËÃÕ­ÃÒ§ÇÑÅÊÙ§ÊØ´
$gd	$sv	$bn		$db[kd_std] ÃÃ.$db1[sname]

"; ?>