update price

[hayesb2]

This is likely simple for most but I'm learning...

 

I have a mysql database, and in the table "products" is a column for "products_price".

 

How do I write the php code to update all of the prices values in the database so they are 15% higher?

[paul2463]

$query = "UPDATE tablename SET pricecolumn = pricecolumn * 1.15";

[hayesb2]

Thank you and what if I wanted to subtract 15%?

Last question

[paul2463]

you would do the same maths for adding 15% to do the subtraction

$query = "UPDATE tablename SET pricecolumn = pricecolumn - 15%"; //however you do that math

[hayesb2]

The thing is I dont know the syntax to do minus 15%

[paul2463]

thats maths syntax to make that happen and I dont know what it is it may be

$query = "UPDATE tablename SET pricecolumn = pricecolumn - ((pricecolumn/100)*15)";

[fenway]

Or "= ROUND( 0.85 * pricecolumn, 2 )"