how to call decimal values from sql into a table

[aizad]

the values in my sql is 1.200... but when i cal it into table it become 1 only..

how i call the data

{
<?php
        while($row = mysql_fetch_array($result)) {
            $id = $row["id"];
            $AddCar = $row["AddCar"];
            $AddPlateNo = $row["AddPlateNo"];
            $AddPackage = $row["AddPackage"];
            $AddMileage = $row["AddMileage"];
            $AddAge = $row["AddAge"];
            $Date = $row["Date"];
            $Month = $row["Month"];
            $Year = $row["Year"];
            $Time = $row["Time"];
 
        $all=mysql_query("SELECT * FROM car WHERE id='$id'");
        $row2=mysql_fetch_array($all);
            $EngineOil = $row2["EngineOil"];
            $BrakeOil = $row2["BrakeOil"];
            $GearOil = $row2["GearOil"];
            $Coolant = $row2["Coolant"];
            $AirFilter = $row2["AirFilter"];
            $Container = $row2["Container"];
    ?>
    <tr>
        <td><?php echo $AddPlateNo; ?> </td>
        <td><?php echo $AddCar; ?> <br></td>
        <td><?php echo $AddPackage; ?></td>
        <td><?php echo $AddMileage; ?></td>
        <td><?php echo $AddAge; ?></td>
        <td><?php echo "$Date/$Month/$Year / $Time"; ?> <br></td>
        <td><?php echo $EngineOil;?></td>
        <td><?php echo $BrakeOil;?></td>
        <td><?php echo $BrakeOil;?></td>
        <td><?php echo $GearOil;?></td>
        <td><?php echo $Coolant;?></td>
        <td><?php echo $AirFilter;?></td>
        <td><?php echo $Container;?></td>
        <td><a href="updateCar.php?id=<?php echo $id; ?>">Update</a>/<a href="buang.php?id=<?php echo $id; ?>">Delete</a></td>
    </tr>
<?php
}

[Exequiel]

what data type did you used for the field of where the data 1.200 came from? because if it is in varchar for me your code is right. you can visit this link.
http://us2.php.net/floatval

[aizad]

the data type is decimal

[aizad]

and it came from $EngineOil,$Bra keOil,$GearOil, $Coolant...the data type in sql/xampp is decimal 5,3....the data in the database is for example is 1.200 but when i call it into the table it become 1 only..can give me your email..i'll send you the pic..pls help..tq

[Exequiel]

if your data type is decimal, in your insertion the data that being saved is always be a whole number, if you want to insert to your table a whole number and a float you can use varchar or double,

[aizad]

still the same..i have change i into varchar..
is there anything wrong here? because the value saved in sql is decimal number.

$EngineOil = $row2["EngineOil"];

<td><?php echo $EngineOil;?></td>

[aizad]

thank you very much..i found my mistake. tq so much

[Exequiel]

your always welcome. . :D