Quote:
|
Originally Posted by shan
heres a simple way to update a column in your database by 10%
Code:
UPDATE xcart_pricing SET price=price/100, price=price*110;
backup your database before you run this if you dont trust it
The first bit divides your price by 100 which will give you 1%
The next bit times it by 110 which gives you your original + 10%  |
Would
Code:
UPDATE xcart_pricing SET price=price/100, price=price*112.5;
add 12.5% ?