Re: Field type for american money

From: 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?).

« previous php.general (#293961) next »