<?php ????require_once('./config/connection.php'); ????//找出所有隊伍 ????$xtteam=mysql_query("SELECT?tid?FROM?team"); ????//$row=mysql_fetch_row($xtteam);將每個隊伍保存到數組中 ????while($row=mysql_fetch_row($xtteam)){ ????????foreach?($row?as?$allcy)?{ ????????????$allcy=mysql_query("SELECT?total?FROM?member?where?team_id=$row?");//先找出同一隊的所有成員 ????????????$cj=0; ????????????while($memrow=mysql_fetch_row($allcy)){ ????????????????foreach?($memrow?as?$mycj)?{ ????????????????????$cj=$cj+$mycj; ????????????????} ????????????????$resultteam=mysql_query("UPDATE?team?set?score=$cj?where?tid=$row?"); ????????????????if($resultteam&&mysql_affected_rows()>0){ ????????????????????echo?"<br?/>Update?<br?/>"; ????????????????}else{ ????????????????????echo?"False".mysql_errno()."?Why:".mysql_error()."<br?/>"; ????????????????} ????????????} ????????} ????} ;?>描述：一個組隊答題系統，想把每個隊伍的每個人的分數匯總后更新到團隊分數表中先列出所有團隊在列出每個團隊的所有人再將每個人的分數累積起來然后更新到team表分數score表有team表 tidscore成員表memberidtotalteam_idNotice: ?Array to string conversion in? on line 8Warning: ?mysql_fetch_assoc() expects parameter 1 to be resource, boolean given 10