X-Cart forums

[PCGear]

Originally Posted by shan

heres a simple way to update a column in your database by 10%

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

UPDATE xcart_pricing SET price=price/100, price=price*112.5;

add 12.5% ?

[B00MER]

http://forum.x-cart.com/viewtopic.php?p=45650#45650