Dear PHP MySQL Programmers,

When I try to 'Delete' the old total then 'Add' new total in same table it take Only one of them...

PHP Code:

  $Old_Total = $hotel_cost - $eht_days_q * $eht_room_q * $eht_room_p;
 $New_Total = $hotel_cost +  $s_days_q  *  $s_room_q  *  $s_room_p;
 
   $update_cost1 = mysql_query("UPDATE `offer` SET hotel_cost='".$Old_Total."' WHERE id='".$Offer_ID."'")or die(mysql_error());
   $update_cost2 = mysql_query("UPDATE `offer` SET hotel_cost='".$New_Total."' WHERE id='".$Offer_ID."'")or die(mysql_error()); 


when i delete one of $update_costX it work fine .. but both is not work only one of them...

What Kind of change should I dO ?!

Many Thanks.

Up...

then you run this script query $update_cost1 updates (lets say) yours record with id = 5, query $update_cost2 updates olso record with id = 5, so it is logical that you see only last query results

Hi kreoton,

What Happen is..

For Example:
if: hotel_cost='20' And: $Old_Total='10' And: $New_Total='4'


The new DB result should be = 14 ($update_cost1 to cut the 10) AND ($update_cost2 to add the 4).


here in my code it comes = 24, So the 10 still not go.. thats mean $update_cost1 not worked.. to cut that old result.

you can try the code in simple page ...

Thanks All,

I got the Soloution By My Self

it was like:

PHP Code:

    $Sub_Total   = $Old_Total + $New_Total;
   $update_cost = mysql_query("UPDATE `offer` SET hotel_cost='".$Sub_Total."' WHERE id='".$Offer_ID."'")or die(mysql_error());