Cheesy Fiestas $tempWin = "Fiestas_Win"; $tempLoss = "Fiestas_Loss"; $tempOTLoss = "Fiestas_OTLoss"; $RecordText = "SELECT SUM($tempWin), SUM($tempLoss), SUM($tempOTLoss) FROM game"; $Record = mysql_query($RecordText); $SeasonRecordText = "SELECT SUM($tempWin), SUM($tempLoss), SUM($tempOTLoss) FROM game WHERE gameId BETWEEN 83 AND 164"; $SeasonRecord = mysql_query($SeasonRecordText); while($row = mysql_fetch_array($Record)){ $wins = $row["SUM($tempWin)"]; $losses = $row["SUM($tempLoss)"]; $otlosses = $row["SUM($tempOTLoss)"]; } while($row = mysql_fetch_array($SeasonRecord)){ $seasonwins = $row["SUM($tempWin)"]; $seasonlosses = $row["SUM($tempLoss)"]; $seasonotlosses = $row["SUM($tempOTLoss)"]; } ?>
REC:
0-0-0  (0.000)
Season 1:
0-0-0  (0.000)
   Cheesy Fiestas 4    vs.     Les Inutiles 0   
Sunday 3/16/14 - 8:30pm        Game #43 (Season 1, Game 43)
Les Inutiles Ranking: 1108        Human Players: 2, Human Goalie: No
 
Team: 1 2 3 F
   Les Inutiles (INU)0000
   Cheesy Fiestas (CHE)0314
 
1st Star
  Ken Arnold
2 Goals, 2 Assists
 
2nd Star
  Mike Mitchell
0 Goals, 3 Assists
 
3rd Star
  Ron Durand
2 Goals, 0 Assists
0Score4
7Shots22
15Hits11
5Faceoffs16
4:18Time On Attack5:00
0/1 (0.0%)Powerplay3/4 (75.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
26:23Ken Arnold (Even Strength) - DeflectionAssists: Mike Mitchell and COMPUTER LW
212:53Ken Arnold (Powerplay) - DeflectionAssist: Mike Mitchell
215:37Ron Durand (Powerplay) - BackhandAssists: Mike Mitchell and Ken Arnold
310:53Ron Durand (Powerplay) - ReboundAssists: Ken Arnold and COMPUTER LW
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC22411101020.02055141900
#41Mike MitchellRD033100020.004420000
#15Ron DurandRW2021020540.005320000