0) ORDER BY pWin_ws DESC"; $q = mysqli_query($cxn, $query); $pWins = 0; $pLosses = 0; while($row = mysqli_fetch_assoc($q)) { $shade = 1 - $shade; if ($shade==0) { $color = $color1; } else { $color = $color2; } echo ""; $id = $row['RetroID']; $Name = $row['FirstName']." ".$row['LastName']; echo ""; echo ""; $pWins = $pWins + $row['pWin_ws']; echo ""; $pLosses = $pLosses + $row['pLoss_ws']; } echo ""; echo ""; echo ""; echo ""; $shade = 1 - $shade; if ($shade==0) { $color = $color1; } else { $color = $color2; } echo ""; echo ""; echo ""; echo ""; ?>
World Series
Player Name pWins pLosses
",$Name,"",number_format($row['pWin_ws'],1),"",number_format($row['pLoss_ws'],1),"
------ ------
TEAM TOTAL FOR SERIES",number_format($pWins,1),"",number_format($pLosses,1),"