PHP中怎样输出显示mysql字段的和?详细代码!

img


mysql数据库佣金表计算佣金总和
在php中显示出来!
应该怎么写?求详细代码!

$sql = "SELECT sum(yongjin) FROM yongjin"
$result = mysqli_query($conn,$sql);

下面应该怎样输出在PHP中显示出来?

select sum(yongjin)

img

试一下这个代码:

$sql = "SELECT sum(yongjin) as yongjin_total FROM yongjin"
$result = mysqli_query($conn,$sql);
$row = mysqli_fetch_array($result);
echo $row['yougjin_total'];