round function issue

[dkruger]

Hi Everyone,

I am having a little problem that I am hoping someone can help me out
with. In one of my scripts, I am working with some dollar values, and
using round to change the result calculated values into a dollar value
with cents etc...so I should be getting $200.43 instead of $200.42987
etc.

The command I am using is:

$total_revenue = round(($renew+$inc_new+$national_rec+$chargeback), 2);

This had been working previously on the old server, but a few days
ago, I transferred everything to a new system, and now it is as though
the round command is ignoring the 2 for decimal places and instead
rounding up to the next dollar value.

I am not 100% sure yet if it is caused by the round command itself, or
when I perform some math on the values used in the round command yet,
the values are taken from a string, and before any calculations are
made with the values, has 0 added to the value from the string, I
think this is supposed to change it to a number instead of a
string...so I am wondering if adding the 0 is causing the problem
perhaps?

Thanks,
David

[Krustov]

<comp.lang.php>
<dkruger>
<Wed, 17 Oct 2007 07:33:06 -0700>
<11**********************@v29g2000prd.googlegroups .com>

I am having a little problem that I am hoping someone can help me out
with. In one of my scripts, I am working with some dollar values, and
using round to change the result calculated values into a dollar value
with cents etc...so I should be getting $200.43 instead of $200.42987
etc.

The command I am using is:

$total_revenue = round(($renew+$inc_new+$national_rec+$chargeback), 2);

This had been working previously on the old server, but a few days
ago, I transferred everything to a new system, and now it is as though
the round command is ignoring the 2 for decimal places and instead
rounding up to the next dollar value.

Never used round() but www.php.net/manual/en/function.number-format.php
might be worth a look .
--
www.vhit.co.uk
www.jpgimage.co.uk
www.phpwhois.co.uk
www.cannabiswindow.co.uk

[dkruger]

On Oct 17, 9:54 am, Krustov <[e-mail]:

<comp.lang.php>
<dkruger>
<Wed, 17 Oct 2007 07:33:06 -0700>
<[e-mail] .com>

I am having a little problem that I am hoping someone can help me out
with. In one of my scripts, I am working with some dollar values, and
using round to change the result calculated values into a dollar value
with cents etc...so I should be getting $200.43 instead of $200.42987
etc.

The command I am using is:

$total_revenue = round(($renew+$inc_new+$national_rec+$chargeback), 2);

This had been working previously on the old server, but a few days
ago, I transferred everything to a new system, and now it is as though
the round command is ignoring the 2 for decimal places and instead
rounding up to the next dollar value.

Never used round() butwww.php.net/manual/en/function.number-format.php
might be worth a look .

--www.vhit.co.ukwww.jpgimage.co.ukwww.phpwhois.co.uk www.cannabiswindow.co.uk

Thanks, I did find that it is not actually caused by the round
function, but it seems a mysql problem, so will need to check it out
over there.