MySQL and AVG() function question.

[ATLien]

I am using the MySQL AVG function to return a average of a colum. When i echo the results of that query, it give me 6 characters, 1 of them being the decimal. I wanted to know if I could round that value up so it is, 3.4 instead of 3.4332. How might I go about doing this?

[csn]

round(x,d)

[ATLien]

an you explain a little more, I am unsure what to do with that.

[matjaz]

he was probably talking about MySQL function:

SELECT ROUND(money,2) FROM ....

i am not sure coz i have never used it. you can check MySQL functions and make numbers come "prepared" from your result set or you read numbers as they are and use PHP function - thats what i usually do:

$x = <your number here>;

$xOnedecimal = number_format($x, 1);

"number_format" is pretty cool function to use...

[ATLien]

thanks, i ended using the PHP round function.