Re: PHP 4.2.2 Float->Mysql addition problem

From: Date: Fri, 03 Feb 2006 12:32:28 +0000
Subject: Re: PHP 4.2.2 Float->Mysql addition problem
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-229800@lists.php.net to get a copy of this message
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 -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

« previous php.general (#229800) next »