Jump to content


Photo

reducing the count for an item in a column


  • Please log in to reply
1 reply to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 26 March 2006 - 06:33 PM

Hi,
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.


#2 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 26 March 2006 - 06:42 PM

Using single quotes (') makes MySQL think it's a string. Just treat it like a column name both times.

update tablename set amount = amount - 1 where ID = '005';





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users