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.     Detroit Dynasty 1   
Sunday 6/1/14 - 4:26pm        Game #74 (Season 1, Game 74)
Detroit Dynasty Ranking: 2193        Human Players: 3, Human Goalie: No
 
Team: 1 2 3 F
   Detroit Dynasty (VET)0011
   Cheesy Fiestas (CHE)0112
 
1st Star
  Ken Arnold
1 Goal, 1 Assist
 
2nd Star
  COMPUTER RW
1 Goal, 0 Assists
 
3rd Star
  I Love Miley Cyrus
1 Goal, 0 Assists
1Score2
11Shots18
11Hits29
5Faceoffs18
5:46Time On Attack6:48
0/1 (0.0%)Powerplay2/5 (40.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
20:44Ken Arnold (Powerplay) - BreakawayUnassisted
311:24COMPUTER RW (Powerplay) - One TimerAssists: Ken Arnold and Andrew Torok
311:56I Love Miley Cyrus (Even Strength) - SnapshotAssists: Matt Taylor and Matt Horcoff
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC112-10101010.02166172100
#5Bryan LockhartLW000-100040.008940000
#41Mike MitchellRD000-100000.0013720000
#83Andrew TorokLD011-100000.004540000