[Regan Shepherd]

Hi,

I'm new to mysql I'm try to do this… see below.
I don't need any PHP code as I'm just trying to update the database via mysql with an sql query.

From the table ic_option_values
Select all of the price_change values that are not equal to 0.
Multiply these by 1.55
Round the values to the nearest whole number

Don't laugh… here's my attempt.

UPDATE *
FROM `ic_option_values`
WHERE `price_change` !=0
SUM(`price_change`* 1.55)
ROUND (`price_change`, 0)

Any help would be most appreciated.

[End User]

Unless I misunderstand your intent, I don't think you want to SUM the values. That'll basically add them all together, resulting in a single value. Is that what you want to do, or....?

Originally Posted by Regan Shepherd

Hi,

I'm new to mysql I'm try to do this… see below.
I don't need any PHP code as I'm just trying to update the database via mysql with an sql query.

From the table ic_option_values
Select all of the price_change values that are not equal to 0.
Multiply these by 1.55
Round the values to the nearest whole number

Don't laugh… here's my attempt.

UPDATE *
FROM `ic_option_values`
WHERE `price_change` !=0
SUM(`price_change`* 1.55)
ROUND (`price_change`, 0)

Any help would be most appreciated.

[Jcbones]

Your query should probably be.

UPDATE `ic_option_values` 
SET `price_change` = ROUND(`price_change` * 1.55) 
WHERE `price_change`!=0

[Regan Shepherd]

Thanks Jcbones… it worked!!

Wanna be coder… I don't think so… great work… thanks again. Cheers!