Good evening. I am trying to remove trailing zeroes from mysql data that is displayed in a table (pic.1). 

[fragment of table (russian)](http://i.stack.imgur.com/sDLWC.png)

My code for the query is pretty much standard:

```
$query = "SELECT * FROM t_transport";
$result = mysql_query($query);

while( ($row = mysql_fetch_array($result)))
{

    echo "<tr>";
    echo "<td>".$row['date']."</td>";
    echo "<td>".$row['driver']."</td>";
    echo "<td>".$row['sortiment']."</td>";
    echo "<td>".$row['amount']."</td>";
    echo "<td>".$row['origin']."</td>";
    echo "<td>".$row['destination']."</td>";
    echo "<td>".$row['tours']."</td>";
    echo "<td>".$row['notes']."</td>";
    echo "<td>".$row['ts']."</td>";
    echo "</tr>";
}

```

The column with the numbers is the 'amount' one. Data is stored as decimal(10,3). Need to remove trailing zeroes, if such appear.

Now I understand, that there have been many solutions to this, I've read them all, but none of them works for me. Please help me altering my query.

Thanks in advance.