Re: Field type for american money
| From: | Waynn Lue | Date: | Thu, 11 Jun 2009 23:46:14 +0000 |
| Subject: | Re: Field type for american money | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-293961@lists.php.net to get a copy of this message | ||
>
> Shawn McKenzie wrote:
>
>> Waynn Lue wrote:
>>
>>> For mysql, it's better to use int and then store it in cents (or
>>> micros) so you can use all integer operations instead of float ones.
>>>
>>>
>> To each his own. Speed or otherwise I don't see a difference between:
>>
>> $total = 19.95 + 3.99; //shipping
>>
>> and
>>
>> $total = 1995 + 399; //shipping
>>
>> Except with the ints you have to format them for display.
>>
>
> You have to format the floats too:
>
> <?php
>
> $total = 5.55 + 9.35;
> echo $total."\n";
>
> ?>
>
Oh, I didn't mean speed within PHP, I meant for mysql operations. I'm not
sure how PHP handles int vs. float operations (though int is usually faster
than float for other languages, isn't it?).