AVG Question and thanks vincent

[Anon]

I am using the SQL function AVG..

it returns 443.3810, but I want it to print as 443.4. (only 1 decimal place, and rounded). Is there a way to do this?

and just wanted to thank vincent for his great site. His section on mysql error reporting as helped me greatly. If you are starting out with mysql and php, do yourself a favor and check out his site.
http://www.hvt-automation.nl/yapf/index.php?cmd=viewitem&itemid=12

[Anon]

another quick question..why won't this work?

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
if ($row['DisType'] == "Transport accident")
{
echo "<b>Type: Technological A";
}
else
{
echo "<b>Type:".$row['DisType'];
}

[tasistro]

try round(%number%,%digits%)

Saludos
Gerardo

[jsagara]

Store the value returned into a PHP variable, then use the printf() function like you would in a C program:

printf("Average: %.1f", $my_ave);

The "%.1f" means print a floating point number with any number of digits before the decimal, but only 1 digit after the decimal.

[[deleted]]

You're welcome.

As for your question, like Gerardo said, use round(), like:

SELECT ROUND(5.376, 1);

[[deleted]]

That should work ok (providing you have the ending } et the very end ofcourse.

If you meant that the IF is not working properly, make sure that $row['DisType'] contains what you think it contains; print it.