Re: PHP 4.2.2 Float->Mysql addition problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Welcome,
Please note that using bc function variables will be of type string. So a code working with numeric values like:

$a = 1;
if( $a )
{
    ...
}

it's ok but with bc functions:

$a = 14.5;
$b = -14.5;
$c = bcadd( $a, $b );
if( $c )
{
   ...
}

will not work as expected ( if( "0" ) is interpreted like a string that is not null and so condition is interpreted as true.

	Andy

Barry wrote:
Barry wrote:
Andrei wrote:

When working with floats with php/mysql I had problems too... When summing amounts I had errors so my solution was using decimal (20, 10) type into mysql for storing amounts and when using sums in php I used bc functions. This way u get exact calculations (depending on bcscale() parameter.



Thanks Andy sounds great.
Changed DB to decimal 10.2

Tried it, but using bcadd i get a value of 0.00.

If you have som sample code lying around somewhere that would be great, or do you know what happened?

Barry
No problem anymore. solved it. but parsing it to an other function it doesnt work.
oh well, at least it's calculating ^-^

Thanks for help :)

Barry


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux