Re: Converting floats to ints with intval
| From: | Paul Waring | Date: | Thu, 06 May 2010 11:19:48 +0000 |
| Subject: | Re: Converting floats to ints with intval | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-304950@lists.php.net to get a copy of this message | ||
David Otton wrote:
On 6 May 2010 11:52, Paul Waring <paul@xk7.net> wrote: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.comIf 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.