mercredi 7 octobre 2020

dbfetch If Statement [closed]

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