Page 1 of 1
Increasing the quantity?
Posted: Fri Nov 03, 2006 4:53 pm
by cturner
Can someone please tell me how I can increase the quantity and put the quantity in a database table? Thanks in advance.
Posted: Fri Nov 03, 2006 4:57 pm
by Burrito
you need to be a little more specific than that please.
Posted: Fri Nov 03, 2006 5:27 pm
by cturner
I am creating a shopping cart and when a user clicks on the order button and if the product is already in the database table I want to increase the quantity.
Posted: Fri Nov 03, 2006 5:30 pm
by feyd
You'll need some form of an UPDATE query.
Posted: Fri Nov 03, 2006 5:35 pm
by cturner
Yes I understand that I need to use the update query but how do I increase the quantity?
Posted: Fri Nov 03, 2006 5:36 pm
by Burrito
Code: Select all
UPDATE `sometable` SET `somefield` = `somefield` + 1