php - 最大数计算错误

Question

患者编号:1,2,3,4,5,6,7,8,9,10

 $result2=mysql_query("select max(patient_id) as maximum from outdoor");
        $row2= mysql_fetch_array($result2);
      echo $res=$row2['maximum'];

它的最大数量为 9 而不是 10。

Answer 1

试试这个

$sql = "select max(CONVERT(patient_id,UNSIGNED INTEGER)) as maximum from outdoor";