in reply to Recalculating DB values
In your script, test for an add or subtract request and either use the new value passed from the script or fetch the current value from the database.
If you choose the former, just UPDATE with that value (don't forget to validate ALL user input - trust no one!). If you did a lookup, add one or subtract one accordingly (i recommend one sub for add and one for subtract in this case), and UPDATE to the database.
If you wish to do a 'global' add or subtract - then you will need to pass all the id's of each product - be sure and use the POST method, as this request will be quite large.
Jeff
R-R-R--R-R-R--R-R-R--R-R-R--R-R-R--
L-L--L-L--L-L--L-L--L-L--L-L--L-L--
|
|---|