postgresql - PHP calculations not working? Help

[vweston]

I switched my DB from MySQL to PostgreSQL. I also upgraded to PHP Version 4.2.3 Everything went great except for one problem. I have some calculations which stopped working, no error but return 0 instead of the proper value.

my columns are defined as follows:
Field Type Length Not Null
lvalue money 4 Yes
hvalue money 4 Yes_

my code is as follows:

while ($gvrrow = pg_fetch_array($vresult)){ 
   $rgemlvalue=$gvrrow[lvalue];
   $rgemhvalue=$gvrrow[hvalue];
   $wgemlvalue=$rgemlvalue * $wholesalefactor;
   $wgemhvalue=$gvrrow[hvalue] * $wholesalefactor;
   $llotvalue=$finishedlotsize * $wgemlvalue;
   $hlotvalue=$finishedlotsize * $wgemhvalue;
   echo "$rgemlvalue   $wholesalefactor   $wgemlvalue - $wgemhvalue";
}

The output is as follows:
$14.00 0.5 0 - 0

Any help would be appreciated.

[hand]

$14.00 * 0.5 = 0 it seems that $14.00 is a character and not a decimal

check, if all values are decimal or integer.

[[deleted]]

A quote from the manual:

"Deprecated: The money type is deprecated. Use numeric or decimal instead, in combination with the to_char function. The money type may become a locale-aware layer over the numeric type in a future release. "

PHP sees the dollar sign as a string and cannot multiply a string with an integer.
Prehaps you can type=cast the value to an int to get rid of the dollar inside your query, or better yet- convert the money-column to a float column.

[chriskl]

No, even better make it a numeric column:

numeric (9,2)

Numeric support arbitrary precision - which is essential for working with money.

Chris

[vweston]

I changed my columns to numeric(9,2) and it now works like a charm. Thanks for the help.