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    vs.     Pucking Allstars 0   
Wednesday 7/9/14 - 10:27pm        Game #98 (Season 2, Game 16)
Pucking Allstars Ranking: 2708        Human Players: 3, Human Goalie: No
 
Team: 1 2 3 OT F
   Pucking Allstars (ALL)00000
   Cheesy Fiestas (CHE)00011
 
1st Star
  COMPUTER G
24/24 Saves, 1.000 Save%
 
2nd Star
  Ken Arnold
1 Goal, 0 Assists
 
3rd Star
  Bryan Lockhart
0 Goals, 1 Assist
0Score1
24Shots18
29Hits28
7Faceoffs23
5:36Time On Attack5:24
0/8 (0.0%)Powerplay1/4 (25.0%)
0Shorthanded Goals0
Scoring: Per Time Goal Assists
41:05Ken Arnold (Powerplay) - BreakawayAssists: Bryan Lockhart and Kyle Gurnett
 
Skaters Position Goals Assists Points +/- GWG PPG SHG Shots Shot% PIMs Hits GV TK FOW FOT PS Gls PS Att
#11Ken ArnoldC1010110714.323912222700
#5Bryan LockhartRD011000020.0041100000
#41Mike MitchellLW000000040.013117100000
#15Ron DurandLD000000010.005700000
#6Kyle GurnettRW011000040.0447121300