sum
| From: | Fifield, Mike | Date: | Mon, 06 May 2002 17:01:00 +0000 |
| Subject: | sum | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-96277@lists.php.net to get a copy of this message | ||
I am using the mysql sum() function to return the "sum" of a bunch of dolor
amounts stored "float" values. But what I get back it something like this
"98.199998855591" it is to precise. All I want is the dolor amounts added up
and rounded up to the closest penny. Is there a better value type to use or
a function that will return the information properly formatted.
Mike Fifield
Charles Schwab & Co, Inc.
WARNING: All e-mail sent to or from this address will be received by the
Charles Schwab corporate e-mail system and is subject to archival and review
by someone other than the recipient.