MySQL and PHP math problem...
| From: | Peter | Date: | Sat, 09 Nov 2002 07:00:06 +0000 |
| Subject: | MySQL and PHP math problem... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-123559@lists.php.net to get a copy of this message | ||
I have a database that stores a value of the type double. I do a SUM()
query on the column and return save the value to a variable called,
'$amount' which I divide into a fixed value (5000) . The math works out
fine when $amount < 1000. However, when $amount > 1000, then the decimal
places are wrong.
// successful query, now fetch the data.
$row = mysql_fetch_row($result);
if (!$row) {
return (-1);
}
$dollar = $row[0];
$tmp = ($dollar)/((double)5000);
echo $tmp;
return ($dollar);
$amount = 1,104.40
the result of echo, $tmp is displayed as '0.0002'. What's wrong here? The
problem only occurs when the value is greater than a 1,000? Could the ','
messed the computation up somehow? I did another computation
$a = 1000
$b = 5000
$c = $a/$b;
Thanks,
-Peter
$c does equal '0.2' which is correct.
$amount