[SOLVED] How to remove decimals in php (sql)?

[Darla]

Hello

 

I am wondering if there are any ways to remove extra decimals in php (or alternatively in sql)? I fetch aome average values from a table, and I wish to keep only one decimal or remove decimals entirely.

Ex:

14.6154 should be 14.6 og just 14.

 

Are there any "ready-to-use" functions for this in php/mysql?

 

Darla

[printf]

// mysql 14.6154 would become 14.6

 

SELECT ROUND(decimal_column, 1) AS rounded_number FROM ...;

 

// php

 

$number = 14.6154;

echo round ( $number, 1 ); // prints 14.6

 

dont include the second argument , 1 to return a rounded whole number (no decimal)

 

 

 

printf

[Darla]

Thanks! That worked perfectly