MySQL value minus 1?

[Helx]

Hi there,

I've been having (more) troubles with SQL :/

I need to get an SQL value (the column is an int) and then minus one from that.
The only problem is, it won't do anything :/ (no errors)

[syntax=php]$q = mysql_query("SELECT * FROM stats WHERE `user` = '{$session_NAME}'");
$q = mysql_fetch_array($q);
$total_stats = $q['total_stats']-1;

mysql_query("UPDATE stats SET `total_stats` = '{$total_stats}' WHERE `user` = '{$session_NAME}'");[/syntax]

I really can't see whats wrong here :<
(And yes, this is for a statistics script. I would like to be able to delete entries)

If anyone could help, that would be amazing

[jacek]

If you don't need the value in the script afterwards you can do it in one query.

[syntax=sql]UPDATE `table` SET `value` = `value - 1 WHERE `id` = 42[/syntax]

[Helx]

Oh XD

I didn't realise that you could use maths operators in SQL statements :/ probably should have googled that first

[bowersbros]

SQL is quite a powerful language. You can nest statements, create procedures (basically functions) and do all sorts of useful things. it is far more advanced than just Select, insert, delete or update.