算出各項出現的次數

for($g=9;$g>6;$g--){
  for($s=1;$s>-1;$s--){
   $query="SELECT raid,count(raid) AS num FROM app_tbl WHERE raid IN (SELECT raid FROM raname_tbl WHERE grade='$g' AND sex='$s') GROUP BY raid ORDER BY raid ASC";
   $sql =pg_query($query) or die($query);
     while($rows=pg_fetch_array($sql)){
      echo $rows[raid]."--num=".$rows[num]."
";
     }
   }
}