Php, not getting any errors yet this code wont update database

[jamesmorris86]

Hey guys, can anyone see what i have done wrong on this code, instead of updating my database it just does nothing at all, no errors, no noting.

if ($enemy_hp <= 0) {

$sql = "UPDATE game_status SET battle = '1' WHERE id=1";

} else {

$sql = "UPDATE game_character SET current_hp = (current_hp-100) WHERE id=1";


    $statement = $dbh->prepare($sql); 
    $statement->execute();

}

 

[jamesmorris86]

No, but I had them running fine before I put them in the if else.

 

[jamesmorris86]

Oh ok, is there any way around this? I tried changing the logic so that a query is defined in the if() and in the else, but im still not having any luck.

 

[jamesmorris86]

I tried that way but it executes the first query regardless of $enemy_hp

 

[jamesmorris86]

Cant see anything wrong with the variable, its echo'ing fine, maybe I should look at it tomorrow with fresh eyes.

Thanks for your help