MySql Decimal Datatype problem

[Nandini]

Hi all

 

I have one database filed like price with DECIMAL(30,2).

 

While inserting values, those values are rounding. I am inserting values through PHP Coding.

 

For example, I am inserting 5.625 but it is inserting as 5.63

I want to insert value 5.625 as 5.62. I have taken datatype as DECIMAL(30,3) but no use.

 

Here is my code

 

<?php
mysql_connect("localhost","root","");
mysql_select_db("sample");
echo "Product Volume: 3.75<br>";
echo "Amount: 1.5<br>";
$total=3.75*1.5;
echo "Total: ".$total;
$total_insert=mysql_query("insert into test (price) values ('".$total."')");
?>

[lordshoa]

can you not trim the last char off ?

[Nandini]

I am not trimming any value. Ho can i do this. I am not well in php. Please

[lordshoa]

<?php
mysql_connect("localhost","root","");
mysql_select_db("sample");
echo "Product Volume: 3.75<br>";
echo "Amount: 1.5<br>";
$total=3.75*1.5;
$total = substr_replace($total ,"",-1);
echo "Total: ".$total;
$total_insert=mysql_query("insert into test (price) values ('".$total."')");
?>

[PFMaBiSmAd]

If you define your column as DECIMAL(30,3) before you insert the data, the mysql part of this will work.

[xyph]

With math

$num = 1234567.89114524;

$num = bcdiv(floor(bcmul($num,100)),100,2);

echo $num;

 

and strings

 

$num = 1234567.891151351;

$num = sprintf( '%01.2f', $num );

echo $num;