[mysql] sum에 활용

<?
include "../../../include/dbconn.php3";
$query="select team,sum(zumsu) as zumsu,sum(goal) as goal, sum(cheri='Y') as vicy,sum(cheri='N') as vicn,sum(cheri='M') as vicm from victory group by team order by zumsu desc,goal desc";
$result=mysql_query($query);
echo "<table width=100% border=1>";
while($row=mysql_fetch_array($result)) {
$no++;
echo "<tr align='center'><td>$no</td><td>$row[team]</td><td>$row[zumsu]</td><td>$row[vicy]</td><td>$row[vicm]</td><td>$row[vicn]</td><td>$row[goal]</td></tr>";

}
echo "</table>";

?>