Stupid math problem

[NerdConcepts]

I cannot add say 1,000 and 1,000

 

$total = '1,000' + '1,000';

when you echo $total it comes out '2'

 

yet if I do $total = '1000' + '1000'; it echos out '2000' like it should, one problem. All my pricing values have commas in them. Almost all if not all will always contain a comma and NOT a period. Just wondering how in the check can I remove the comma, add the values, then replace it?

 

BTW, it's for a profit/loss chart. It scans a list a purchased and sold vehicles and does some math and spits out totals. Values are stored as a VARCHAR(20) in the database. Not sure what needs to be done, not sure if storing the numbers different would fix the problem or what.

[SJames]

The problem is that 1,000 is a string, not a number. Removing the comma will make it a number. The following should work:

 

 

$number1 = "1,000";

$number2 = "1,000";

 

$number1 = str_replace(",", "", $number1);

$number2 = str_replace(",", "", $number2);

 

$total = $number1 + $number2;

 

$total = number_format($total);

 

 

Now when you echo $total, it comes out to 2,000

[gerkintrigg]

or just:

$number1=1000;
$number2=1000;
$total=number_format($number1+$number2);
echo $total;

[NerdConcepts]

That is easy, how come I always run into problems on the easy things, lol.

[bmdsherman]

Your original script was basically saying:

 

$total = 1 + 000 + 1 + 000

[Psycho]

If these values are coming from a database you shoudl really consider saving the values as nubers and not strings to begin with. You can always format the number when printing to a page.