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 2    vs.     Focus 1   
Friday 6/6/14 - 11:42pm        Game #79 (Season 1, Game 79)
Focus Ranking: 6094        Human Players: 4, Human Goalie: No
 
Team: 1 2 3 OT F
   Focus (FCS)10001
   Cheesy Fiestas (CHE)01012
 
1st Star
  Ken Arnold
2 Goals, 0 Assists
 
2nd Star
  Ron Durand
0 Goals, 1 Assist
 
3rd Star
  John Meanjean
1 Goal, 0 Assists
1Score2
9Shots22
32Hits23
13Faceoffs11
6:03Time On Attack7:13
0/0 (0.0%)Powerplay1/4 (25.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
10:45John Meanjean (Even Strength) - Clutch CloutsAssist: Matt Ebbett
24:05Ken Arnold (Even Strength) - BreakawayUnassisted
46:10Ken Arnold (Powerplay) - SnapshotAssists: COMPUTER RW and Ron Durand
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC20201101020.002710112401
#5Bryan LockhartLD000000030.004740000
#41Mike MitchellRD000000030.0066100000
#15Ron DurandRW011000040.006860000