I am trying to reduce a number in my column by 1. I need to do this as on my php script when someone buys a product the amount should reduce by 1. I have tried the following:
update tablename set amount = 'amount' - 1 where ID = '005';
update tablename set amount = 'amount - 1' where ID = '005';
The first statement doesnt changes the amount to -1. The second statement sets the amount to 0. What statement should i be using in mysql?? as i then need to use the statement in my php page.
reducing the count for an item in a column
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users