increase item by 1

[raffael3d]

lets say in the column "qty" is the value 1.

now I want to create a button that each time it is clicked it increases the value by one.

what is the msyql command for adding 1?

this only replaces the value, but it should increas it:
$query=mysql_query("UPDATE shop SET qty='$qty' WHERE id='$updateqty'");

thanks.

[AstroTeg]

"UPDATE shop SET qty = (qty + 1) WHERE id=" . $updateqty