I am using a db_fetch command followed by if, ifelse and if. The Idea is that if HDiff > Homescore then Homewin = 1 or if ADiff > AwayScore then Awaywin = 1. Else both = 0. The statement is not pulling up any errors but it does not work properly as Awaywin does not =1 even when fulfilling the above criteria.
$row = db_fetch_item("select (AwayScore + PensRemainingAway) As ADiff,
(HomeScore + PensRemainingHome) As HDiff,
HomeScore, AwayScore, SuddenDeath
from SessionLogs
Where Penalty = '1'
AND ActiveStatusID = 1");
if ($row['HomeScore'] > $row['ADiff']) {
db_query("update SessionLogs set HomeWin = 1 where Penalty = '1' AND ActiveStatusID = 1");
} elseif ($row['AwayScore'] > $row['HDiff']) {
db_query("update SessionLogs set AwayWin = 1 where Penalty = '1' AND ActiveStatusID = 1");
} else {
db_query("update SessionLogs set AwayWin = 0 where Penalty = '1' AND ActiveStatusID = 1");
db_query("update SessionLogs set HomeWin = 0 where Penalty = '1' AND ActiveStatusID = 1");
}
Aucun commentaire:
Enregistrer un commentaire