max() 求最大值, count() 求行数 , avg() 求平均函数, min() 求最小值 , sum() 求总和
<?php
header("Content-type:text/html;charset=utf8");
include "cmcntBD.php";
$sql="select h_name,count(1) from message group by h_name";
$result=mysqli_query($conn, $sql);
while($row=mysqli_fetch_array($result))
{echo $row['h_name']."___total is___ ";
echo $row['count(1)'];
echo "<br>";
}
mysqli_close($conn);
?>