[RESOLVED] Relative Decrease

[Staggy11]

I'm trying to decrease a column in my SQL table by 1 each time a specific requirement is met.

Right now, I'm having to use a query to find the current value, subtract 1, then use another query to update the table.
However, I know that you can use ++ to increase a variable relatively. Is there a similar function for decreasing? That way I could just do something like

<?
$update=mysql_query("UPDATE `players` SET `Ap`= -- WHERE username='".$_SESSION['username']."'") or die(mysql_error()); ?>

[tsinka]

Hi,

you can do something like

$update=mysql_query("UPDATE players SET Ap=Ap-1 WHERE username='".$_SESSION['username']."'") or die(mysql_error());

Thomas

[Staggy11]

Thanks, that works perfectly!