Roach Posted January 25, 2008 Share Posted January 25, 2008 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 Link to comment https://forums.phpfreaks.com/topic/87796-solved-easy-one-for-you-adding-totals/ Share on other sites More sharing options...
Roach Posted January 25, 2008 Author Share Posted January 25, 2008 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. Link to comment https://forums.phpfreaks.com/topic/87796-solved-easy-one-for-you-adding-totals/#findComment-449077 Share on other sites More sharing options...
Roach Posted January 25, 2008 Author Share Posted January 25, 2008 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........ Link to comment https://forums.phpfreaks.com/topic/87796-solved-easy-one-for-you-adding-totals/#findComment-449092 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.