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 3    at     Hitman QC 0   
Monday 3/3/14 - 12:41am        Game #23 (Season 1, Game 23)
Hitman QC Ranking: 13214        Human Players: 4, Human Goalie: No
 
Team: 1 2 3 F
   Cheesy Fiestas (CHE)0213
   Hitman QC (QC)0000
 
1st Star
  COMPUTER G
28/28 Saves, 1.000 Save%
 
2nd Star
  Kyle Gurnett
1 Goal, 1 Assist
 
3rd Star
  Ken Arnold
1 Goal, 1 Assist
3Score0
16Shots28
22Hits16
15Faceoffs11
6:58Time On Attack5:43
0/1 (0.0%)Powerplay0/2 (0.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
216:21Kyle Gurnett (Even Strength) - SnapshotAssists: COMPUTER LD and COMPUTER G
217:24COMPUTER RD (Even Strength) - SlapshotAssist: Ken Arnold
318:51Ken Arnold (Even Strength) - One TimerAssist: Kyle Gurnett
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC1123000616.7241010142000
#5Bryan LockhartRW000200000.028341500
#15Ron DurandLD000300000.005740000
#6Kyle GurnettLW1123100425.024680000