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)