<br /> $query = "<br /> SELECT Team,On,Tw,Th,Fo,Fi,Si,Se,Ei,Ni<br /> FROM base_ball<br /> WHERE date='$date'<br /> ";<br /> $sth = $dbh -> do_query($query);<br /> $total = $dbh -> total_rows($sth);<br /><br /> for($i=0;$i<$total;$i++){<br /><br /> list ($team,$one,$two,$three,$four,$five,$six,$seven,$eight,$nine) = $dbh -> fetch_array($sth);<br /><br /> $scorescolumn[$i]['team'] = $team;<br /> $scorescolumn[$i]['one'] = $one;<br /> $scorescolumn[$i]['two'] = $two;<br /> $scorescolumn[$i]['three'] = $three;<br /> $scorescolumn[$i]['four'] = $four;<br /> $scorescolumn[$i]['five'] = $five;<br /> $scorescolumn[$i]['six'] = $six;<br /> $scorescolumn[$i]['seven'] = $seven;<br /> $scorescolumn[$i]['eight'] = $eight;<br /> $scorescolumn[$i]['nine'] = $nine;<br /> $scorescolumn[$i]['score'] = $scorescolumn[$i]['one']+$scorescolumn[$i]['two']+$scorescolumn[$i]['three']+$scorescolumn[$i]['four']+$scorescolumn[$i]['five']+$scorescolumn[$i]['six']+$scorescolumn[$i]['seven']+$scorescolumn[$i]['eight']+$scorescolumn[$i]['nine'];<br /><br /> $dbh -> finish_sth($sth);<br />}<br /><br /> for($i=0;$i<$total;$i++){<br /><br /> $query = "<br /> UPDATE base_ball<br /> SET Tot='{$scorescolumn[$i]['score']}'<br /> WHERE Date='$date'<br /> AND Team='{$scorescolumn[$i]['team']}'<br /> ";<br /> $dbh -> do_query($query);<br />}<br />