My price does not seem to be updating

[oracle765]

Hi Professionals

 

I have problems with my code and I cannot figure out why it is not updating the price by 1

 

Within the database the merchant table price is decimal 10.2 and the name is varchar

 

 

thanks

config.php

masters.php

[gristoi]

<? 

include_once('includes/config.php'); 

 $increment = 1; 

 //get values of each member 

 $query="SELECT `name`, `price` FROM merchant"; 

 $result=mysql_query($query); 

 

 $num=mysql_num_rows($result); 

 while ($row = mysql_fetch_array($result)) 

 { 

    $value = (float)$row['price] + (float)$increment; 

    $query2 = "UPDATE merchant SET `price`='$value' WHERE `name`='Harvey Norman' and price ='141.00'"; 

    $result2 = mysql_query($query2); 

 } 

 // close connection 

 mysql_close(); 

 ?>

[Barand]

if you have 1000 records in that table then you run that update 1000 times. All you need is

$query2 = "UPDATE merchant SET price= price+$increment WHERE `name`='Harvey Norman' and price = 141.00 "; 
$result2 = mysql_query($query2);

[oracle765]

ive tried that and my dreamweaver php editor shows and error for the last 2 lines of code you provided $query2,$result2