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)"]; } ?>
Home
Roster
Schedule
Statistics
Media
Forum
REC:
0-0-0 (0.000)
Season 1:
0-0-0 (0.000)
#
Cty
Name
1st Pos.
2nd Pos.
Player Type
Gamertag
Exp.
Active?
5
Bryan Lockhart
Left Wing
Left Defenseman
Sniper
xlCassiveMocklx
1
Yes
6
Kyle Gurnett
Left Defense
Right Wing
Offensive Defenseman
Eldi
1
Yes
11
Ken Arnold
(C)
Center
Left Wing
Playmaker
TheGreat0ne11
1
Yes
14
Sean Cuvelier
Right Wing
Right Defense
Two Way Forward
BigRon8369
1
Yes
15
Ron Durand
Right Wing
Left Defense
Two Way Forward
BigRon8369
1
Yes
41
Mike Mitchell
Right Defense
Right Wing
Defensive Defenseman
The El Mitchell
1
Yes
83
Andrew Torok
Right Wing
Right Defense
Two Way Forward
T0ROKA
1
Yes
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