David Otton wrote:
On 6 May 2010 11:52, Paul Waring <paul@xxxxxxx> wrote:
If I was designing the system from scratch, that's what I'd do.
Unfortunately this is an add-on to a legacy system where currency values are
already stored as strings in the database (yes, not ideal I know, but you
have to work with what you've got).
I don't know much about your situation, but it does sound like you
need to fix the root problem. I'd use a decimal type, and lean on the
database to do the maths.
As I said, unfortunately it's a legacy system, so I can't just change
the database to use a different type (there are dozens of columns set up
like this, with thousands of values already set).
--
Paul Waring
http://www.pwaring.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
