Question

MYSQL中用SUM函数求和，如何将结果输出在页面上？

语句：
$SQL="SELECT SUM(COST) FROM LIST";
mysql_query($sql);
如何将求得的结果输出在php页面上？

Answer 1

$sql = "SELECT SUM(COST) sum FROM LIST";

$res = mysql_query($sql);
$row = mysql_fetch_assoc($res);

echo $row['sum'];