[RESOLVED] Help with Update

[dr_overload]

Can anyone please tell me why the secord part of my script is not updating with value 5. The first part works fine and is updating to value 4.

$goals = 4;
$goalsx = $goals++;
if ( $info['match_score_ga1h'].$info['match_score_ga1a'] == $info['ga1h'].$info['ga1a'] && $info['ga1h'] + $info['ga1a'] <= $goals) {
$result = "UPDATE world_cup_users SET pts_ga1 = '4' WHERE username ='$username'";
echo $goals;

} elseif ( $info['match_score_ga1h'].$info['match_score_ga1a'] == $info['ga1h'].$info['ga1a'] && $info['ga1h'] + $info['ga1a'] == $goalsx) {
$result = "UPDATE world_cup_users SET pts_ga1 = '5' WHERE username ='$username'";
echo $info['match_score_ga1h'] + $info['match_score_ga1a'];

Thanks

[bradgrafelman]

Since this is an elseif, and you're saying the 2nd set of code never runs, we can deduce that the second conditional is never met. So, it's never set to 5 because ($info['ga1h'] + $info['ga1a']) is never equal to 4.

Going into the if/elseif code above, $goals is 5 and $goalsx is 4. Is this what you expected?

[dr_overload]

Thanks for your help.

The secord set of code is being met but is not updating the table, however it is displaying the correct figure requested via echo.

Even when ($info['ga1h'] + $info['ga1a']) = 5 some reason the database is being updated with 4 not 5.

[bradgrafelman]

The database will only be updated to 5 if those two $info pieces are equal to 4, not 5.

When those two are equal to 4, the database should be updated to 5. You can add an echo statement inside each set so we know where the script is going, i.e. in the top you'd put echo "first set"; and in the second echo "second set"; or something of that nature.