Re: PHP 4.2.2 Float->Mysql addition problem
| From: | Barry | 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:
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)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.