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 1    at     Blue Mountain St 2   
Monday 2/24/14 - 4:14pm        Game #12 (Season 1, Game 12)
Blue Mountain St Ranking: 2534        Human Players: 2, Human Goalie: No
 
Team: 1 2 3 F
   Cheesy Fiestas (CHE)0101
   Blue Mountain St (BMS)0112
 
1st Star
  Lewis Collins
2 Goals, 0 Assists
 
2nd Star
  Matt Stephenson
0 Goals, 1 Assist
 
3rd Star
  Andrew Torok
1 Goal, 0 Assists
1Score2
24Shots18
18Hits15
18Faceoffs9
6:38Time On Attack4:20
0/2 (0.0%)Powerplay0/2 (0.0%)
1Shorthanded Goals0
Scoring: Per Time Goal Assists
24:19Lewis Collins (Even Strength) - SnapshotUnassisted
214:16Andrew Torok (Even Strength) - One TimerAssists: Ken Arnold and COMPUTER LD
313:49Lewis Collins (Even Strength) - SnapshotAssists: Matt Tyrell and Matt Stephenson
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC011-100060.02364182600
#83Andrew TorokLW101-10011010.024140000