Update query, don't go below 0?

[cdoyle]

Hi

I'm using this update query, to update the 'Awake' column.

 

$statupdate=($player->energy*$player->Awake)/100;
$energyreduce=($_POST['trainamount']);
$awakereduce=($player->Awake - ($_POST['trainamount'] * .4));


$updatestrength = $db->execute("UPDATE `players` SET `strength`= `strength`+?, `Awake`=?, `energy`= `energy`-? WHERE `id`=?", array($statupdate,  $awakereduce, $energyreduce, $player->id));

 

which works fine, but if a player has less 'Awake' then what $awakereduce value is,

It gives them a negative number.

How would I change this so, instead of updating the 'Awake' column with a negative number.  It just updates it to 0?

 

 

[DarkWater]

Do a check before the query.  It would look something like:

 

$awakereduce = ($awakereduce < 0) ? 0 : $awakereduce;

[cdoyle]

Do a check before the query.  It would look something like:

 

$awakereduce = ($awakereduce < 0) ? 0 : $awakereduce;

 

Thanks, that worked great!