Problem with Decimal datatype

[4rxsid]

Hi all,

I've got a MySQL column decimal(7,2) datatype.

no matter 7 digit number I tried to insert via web form & php, when the db is queried...it returns all 9's.
My Form has two boxes, with box var0 up to 5 digits possible and var1 up to 2 digits.

$var0 = preg_replace("/[^0-9]/i", "", $var0);
$var1 = preg_replace("/[^0-9]/i", "", $var1);
if ($var1 == "") {
    $var1 = "00";
}
//$var = $var0 . $var1;  //ALSO TRIED THIS W/SAME RESULTS
$var = $var0 . "." . $var1;

Is there a function I need to use to insert my numeric data into the db?

Thanks.

[nemonoman]

Please post the code you are using to insert $var into your MySQL row.

Your results of 9999999.99 suggest that you are inserting a number that is greater than 9999999.99.

If for example your statment is:

INSERT INTO sometable SET somecolumn='$var'

I think you might want to print out $var and see what you're actually trying to insert.

Here's what I would do. Convert $var to a number and leave off the quotes in the SQL:

$var=($var01)+(round($var1,2).01);
mysql_query(
"INSERT INTO INSERT INTO sometable SET somecolumn=$var");

//NOTE: NO QUOTES around $var; insert $var as a number

[4rxsid]

nemonoman...you right about trying to insert a number larger than what I set for the decimal!
The web form was accepting up to 10 digits, and I was testing in this particular case with the max allowed on the form. Once I limited the form to the 7 max allowed in the db, it corrected the problem. Not to mention inserting as a number and not a string!

thanks!