Inserting float value of 1,226.37 into Decimal(10,2) table column

[SchweppesAle]

Hi, whenever I try inserting a float value of 1,226.37 into a Decimal(10,2) table column; all I see is 1. 

 

Is there a reason why this happens?

 

Thanks

[PFMaBiSmAd]

That's because a 1000's comma is a human convention to make a number more human readable. It has no meaning to a computer and in fact most computer programs stop parsing numbers at the first non-number, which is why you are only getting a 1.

 

You need to remove any commas from numbers. str_replace would probably be the quickest function to use - http://us3.php.net/manual/en/function.str-replace.php

[SchweppesAle]

You're absolutely right.  I just picked that up a few minutes ago. 

 

I hadn't realized that the value being returned by another function was actually a string and not a float value. 

 

Thanks for your help.