datatype for 9 place decimal

[ftsw]

Problem: inside php script need to multiply and find $a.
$x, $y, and $z are all datatype float(11,9) inside the carv table. I connect to database and select these values from carv table.
$x= 0.000182682
$y= 0.028863719
$z= 0.452137381

I do this multiplication inside my php script to find $a.
$a = $x * $y * $z
$a = 2.3840670190801E-006
This multiplication is obviously wrong.
Can you please help?
Sheldon

 

[danielhozac]

Wow! Those are some small numbers that needs to be multiplied... You do realize that the result would have 27 decimals, right? I'm not sure PHP can handle that, but have you checked the [tt]precision[/tt] variable in [tt]php.ini[/tt]?

//Daniel

 

[sleipnir214]

I recommend that you use PHP's bc_match functions (

http://www.php.net/manual/en/ref.bc.php).

The following script:

<?php
bcscale (100);

$x= 0.000182682;
$y= 0.028863719;
$z= 0.452137381;

print bcmul(bcmul($x, $y), $z);
?>

Which produces as output:

0.000002384067019080092416398

which may be what you're looking for.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[casters]

Sheldon,
why you say the result is wrong? I've not verified, but it seems correct.
Gaetano

 

[sleipnir214]

And it does jibe with my calculator and bcmath.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!