[RESOLVED] MySQL Decimal

[kterry]

I have a web app that is pulling data from MySQL database and placing it into rows. One of the column's data type is DECIMAL(10,1). When PHP queries the database and prints the data, it is showing the data that I do not want to show a decimal point as (example) 20.0, 22.0...so on. I only want data with a decimal greater than 0 to show the decimal (20.1, 20.2...so on). How can I truncate the .0 off?

[NogDog]

You can cast it to float within PHP:

echo (float) $value_from_db;

[kterry]

You are awesome!