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 4    at     Prolapsia 0   
Wednesday 3/12/14 - 7:47pm        Game #42 (Season 1, Game 42)
Prolapsia Ranking: 8395        Human Players: 4, Human Goalie: No
 
Team: 1 2 3 F
   Cheesy Fiestas (CHE)1124
   Prolapsia (PRL)0000
 
1st Star
  Bryan Lockhart
2 Goals, 1 Assist
 
2nd Star
  Ken Arnold
1 Goal, 2 Assists
 
3rd Star
  Sean Cuvelier
1 Goal, 2 Assists
4Score0
27Shots15
22Hits27
16Faceoffs12
8:18Time On Attack5:51
0/3 (0.0%)Powerplay0/1 (0.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
16:18Bryan Lockhart (Even Strength) - One TimerAssists: Ken Arnold and Sean Cuvelier
219:47Ken Arnold (Even Strength) - BreakawayUnassisted
31:24Sean Cuvelier (Even Strength) - One TimerAssists: Bryan Lockhart and COMPUTER LD
312:04Bryan Lockhart (Even Strength) - One TimerAssists: Sean Cuvelier and Ken Arnold
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC1234000812.50348152700
#5Bryan LockhartLW2134100922.2066100000
#41Mike MitchellRD000400030.007480000
#14Sean CuvelierRW1234000616.726360000