Easy MySQL question

[ryeman98]

I want to decrement without having to retrieve the value by selecting and turning it into an array, blah blah blah.

 

How do I do something like this:

<?php
$update = mysql_query("UPDATE `table` SET amount='{amount-1}' WHERE id='$id'");
?>

[trq]

$update = mysql_query("UPDATE `table` SET amount=amount-1 WHERE id='$id'");

[ryeman98]

$update = mysql_query("UPDATE `table` SET amount=amount-1 WHERE id='$id'");

 

Simple enough ... didn't think it would work but I guess I'll try it

[trq]

Thats a great idea.

[ryeman98]

Thats a great idea.

 

Didn't work. amount was 10 and it was supposed to take away 1 but took away all 10.

[trq]

What field type is amount?

[Darklink]

Use INT or DOUBLE.