Hello to everyone,
I'm new here - Great forum.
I would like to update an entire database at once.
I use Mysql database and PhP scripts.
I explain : I have to update prices in one column of the DB by puting +10%
This is what I have but it takes the first price, put +10% and update all prices with this same value, and the idea is I update all prices that are all different, so I suppose to get all different result !
I first select * from the DB where kind=$kind
then I update :
$Price_Ex_1 = $Price_Ex *10/100;
$Price_Ex_2 = $Price_Ex + $Price_Ex_1;
$q = "update DB set Price_Ex = '$Price_Ex_2'
where Kind = $kind
For sure this won't give the expected result !!
Can somebody please help me ?
In advance many thanks.