Simple Addition issue
| From: | Herhuth, Ron | Date: | Tue, 25 Mar 2003 14:45:47 +0000 |
| Subject: | Simple Addition issue | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-19129@lists.php.net to get a copy of this message | ||
I have a very dumb question that I'm puzzled with. I am creating a script that is returning
tow values from a DB...The values will either be a number or the word resident so i'm checking
for that first...if they are indeed numbers they need to be added together storing the sum in a
variable which will give the total later in the script. For some reason I keep getting back a very
incorrect value when using the script below:
$total_state_income = 0;
$row['CA_state_source_income'] = "14,133";
$row['GA_state_source_income'] = "Resident";
$row['IL_state_source_income'] = "10,556";
if(!strchr($row['CA_state_source_income'],"Resident"))
{
$total_state_income = $total_state_income + (int)$row['CA_state_source_income'];
}
if(!strchr($row['GA_state_source_income'],"Resident"))
{
$total_state_income = $total_state_income + (int)$row['GA_state_source_income'];
}
if(!strchr($row['IL_state_source_income'],"Resident"))
{
$total_state_income = $total_state_income + (int)$row['IL_state_source_income'];
}
When I check the value of $total_state_income it equals 24 not the expected 24,689.
The datatype of the values returned from SQL Server are Varchar so I tried typecasting the values to
integers before adding them to the running total.
What am I doing wrong??
Thanks in advance for your help,
Ron