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    at     Los Santos Sabres 1   
Sunday 3/23/14 - 2:45pm        Game #55 (Season 1, Game 55)
Los Santos Sabres Ranking: 3929        Human Players: 3, Human Goalie: No
 
Team: 1 2 3 F
   Cheesy Fiestas (CHE)0112
   Los Santos Sabres (LSS)0011
 
1st Star
  Mike Mitchell
1 Goal, 0 Assists
 
2nd Star
  Ken Arnold
0 Goals, 2 Assists
 
3rd Star
  Bryan Lockhart
1 Goal, 0 Assists
2Score1
9Shots18
19Hits14
12Faceoffs6
5:28Time On Attack6:12
1/2 (50.0%)Powerplay0/1 (0.0%)
1Shorthanded Goals0
Scoring: Per Time Goal Assists
23:31Bryan Lockhart (Even Strength) - One TimerAssist: Ken Arnold
39:09Shanks (Even Strength) - BreakawayAssists: Danglez and Matt Boyle
318:27Mike Mitchell (Powerplay) - SnapshotAssist: Ken Arnold
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC022000040.003108121800
#5Bryan LockhartLW1010001250.005400000
#41Mike MitchellRD101-1110250.028720000
#6Kyle GurnettLD000000000.008220000