View Single Post
  #9  
Old 03-24-2004, 09:43 AM
  shan's Avatar 
shan shan is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Birmingham, UK
Posts: 6,163
 

Default

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%
__________________
Looking for a reliable X-cart host ?
You wont go wrong with either of these.

EWD Hosting
Hands On Hosting
Reply With Quote