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