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)
# Cty Name 1st Pos. 2nd Pos. Player Type Gamertag Exp. Active?
5Bryan LockhartLeft WingLeft DefensemanSniperxlCassiveMocklx1Yes
6Kyle GurnettLeft DefenseRight WingOffensive DefensemanEldi1Yes
11Ken Arnold (C)CenterLeft WingPlaymakerTheGreat0ne111Yes
14Sean CuvelierRight WingRight DefenseTwo Way ForwardBigRon83691Yes
15Ron DurandRight WingLeft DefenseTwo Way ForwardBigRon83691Yes
41Mike MitchellRight DefenseRight WingDefensive DefensemanThe El Mitchell1Yes
83Andrew TorokRight WingRight DefenseTwo Way ForwardT0ROKA1Yes
Offense: Defense: Goalie:
1. Ken Arnold 1. Kyle Gurnett 1. Andrew Torok
2. Bryan Lockhart 2. Bryan Lockhart 2. Mike Mitchell
3. Kyle Gurnett 3. Mike Mitchell 3. Ron Durand
4. Andrew Torok 4. Andrew Torok 4. Ken Arnold
5. Sean Cuvelier 5. Sean Cuvelier 5. Sean Cuvelier
6. Mike Mitchell 6. Ron Durand 6. Bryan Lockhart
7. Ron Durand 7. Ken Arnold 7. Kyle Gurnett
         
 
 
 
 
 
 
 
    Left Wing:     Center:     Right Wing:
    Bryan Lockhart     Ken Arnold     Ron Durand
    Sean Cuvelier
 
    Left Defense:     Right Defense:
    Kyle Gurnett     Mike Mitchell
    Goalie:
    Andrew Torok