[SOLVED] easy one for you adding totals

[Roach]

I thought I had this working and everything was fine however I see that its not adding the totals so back to that

any help appreciated.

 

$strQuery =("update {$db_prefix}tablename set revenue=revenue+'".$mc_gross."', revenue_type='4', activate='".$fecha."' WHERE campaignid='".$new_ID."'");
    $result = mysql_Query($strQuery4) or die (mysql_error());

 

can you see the error in the adding? I swear it worked yesterday. Its not returning an error and is doing the update less the total.

 

mysql 5.0.45-community

php 5.2.4

 

[Roach]

sorry dont see an edit post button.

 

yes I see I have $strQuery and $strQuery4 was just changing some code before posting here. yes I know it should be the same. dont see a way to edit it now.

[Roach]

I thought I had this working and everything was fine however I see that its not adding the totals so back to that

any help appreciated.

 

$strQuery =("update {$db_prefix}tablename set revenue=revenue+'".$mc_gross."', revenue_type='4', activate='".$fecha."' WHERE campaignid='".$new_ID."'");
    $result = mysql_Query($strQuery4) or die (mysql_error());

 

can you see the error in the adding? I swear it worked yesterday. Its not returning an error and is doing the update less the total.

 

mysql 5.0.45-community

php 5.2.4

 

 

works today with set revenue=+'".$mc_gross."'

 

weird swear it was working yesterday........