<?php ????require_once('./config/connection.php'); ????//找出所有隊伍 ????$xtteam=mysql_query("SELECT?tid?FROM?team"); ????//$row=mysql_fetch_row($xtteam);將每個隊伍保存到數(shù)組中 ????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?/>"; ????????????????} ????????????} ????????} ????} ;?>描述：一個組隊答題系統(tǒng)，想把每個隊伍的每個人的分?jǐn)?shù)匯總后更新到團(tuán)隊分?jǐn)?shù)表中先列出所有團(tuán)隊在列出每個團(tuán)隊的所有人再將每個人的分?jǐn)?shù)累積起來然后更新到team表分?jǐn)?shù)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