如何在表输出中舍入mysql列

Question

I need to round a result of a SQL round in a table array output. I can't figure out the syntax...

$result = mysql_query("SELECT `Energ_Kcal`*`yield`*`qty` AS `cal` FROM allinnot a
WHERE `own_id` = $user->id");

    echo "<tr><td>" . $row['Shrt_Desc'] . "</td><td>&nbsp;" . $row['desc'] . "</td><td>" . $row['cal'] . " cal</td></tr>";

cal returns a value with many numerals beyond the decimal. I just need it to show a whole rounded integer. I tried ROUND(), but I must be putting it in the wrong place.

Answer 1

general syntax

ROUND( expression, 2 )