Re: [PHP] How to sum monetary variables

2011-07-18 Thread Paul M Foster
On Mon, Jul 18, 2011 at 11:22:00PM +0100, Tim Streater wrote: > On 18 Jul 2011 at 23:00, Martín Marqués wrote: > > > I'm building a table (which is a report that has to be printed) with a > > bunch of items (up to 300 in some cases) that have unitary price > > (stored in a numeric(9,2) field),

Re: [PHP] How to sum monetary variables

2011-07-18 Thread Adam Richardson
2011/7/18 Richard Quadling > 2011/7/18 Martín Marqués : > > > > Any ideas? > > For financial values, I use the money type. > > I use MS SQL, but PostgreSQL has > http://www.postgresql.org/docs/9.0/interactive/datatype-money.html > The version of PostgreSQL plays a role, too, as at one point the

Re: [PHP] How to sum monetary variables

2011-07-18 Thread Richard Quadling
2011/7/18 Martín Marqués : > I'm building a table (which is a report that has to be printed) with a > bunch of items (up to 300 in some cases) that have unitary price > (stored in a numeric(9,2) field), how many there are, and the total > price for each item. At the end of the table there is a tota

RE: [PHP] How to sum monetary variables

2011-07-18 Thread admin
> -Original Message- > From: Martín Marqués [mailto:martin.marq...@gmail.com] > Sent: Monday, July 18, 2011 6:01 PM > To: PHP General > Subject: [PHP] How to sum monetary variables > > I'm building a table (which is a report that has to be printed) with a >

Re: [PHP] How to sum monetary variables

2011-07-18 Thread Adam Richardson
2011/7/18 Martín Marqués > I'm building a table (which is a report that has to be printed) with a > bunch of items (up to 300 in some cases) that have unitary price > (stored in a numeric(9,2) field), how many there are, and the total > price for each item. At the end of the table there is a tota

Re: [PHP] How to sum monetary variables

2011-07-18 Thread Tim Streater
On 18 Jul 2011 at 23:00, Martín Marqués wrote: > I'm building a table (which is a report that has to be printed) with a > bunch of items (up to 300 in some cases) that have unitary price > (stored in a numeric(9,2) field), how many there are, and the total > price for each item. At the end of th

RE: [PHP] How to sum monetary variables

2011-07-18 Thread Jasper Mulder
> Date: Mon, 18 Jul 2011 19:00:52 -0300 > From: martin.marq...@gmail.com > To: php-general@lists.php.net > Subject: [PHP] How to sum monetary variables > > I'm building a table (which is a report that has to be printed) with a > bunch of items (up to 300 in some case

[PHP] How to sum monetary variables

2011-07-18 Thread Martín Marqués
I'm building a table (which is a report that has to be printed) with a bunch of items (up to 300 in some cases) that have unitary price (stored in a numeric(9,2) field), how many there are, and the total price for each item. At the end of the table there is a total of all the items. The app is run