Decimal Compare not working

[Hans Brost]

I have 2 Decimal(8,5) fields in my DB (MACDPrev and MACD). When I look at a row in Search in PHP MyAdmin, they both show values of -0.00006.

However in my script a comparison of PHP is indicating one is less than the other.

The MACDDIR field is being set to 'U' instead of 'E':

If ($MstMACDPrev < $MstMACD)
$MstMACDDir = 'U';
else
If ($MstMACDPrev > $MstMACD)
$MstMACDDir = 'D';
else
$MstMACDDir = 'E';

Other comparisons also show them as one being larger than the other instead of being equal

I thought Decimals were stored as exact values with the indicated nr of decimal places?


z