MAX（）函数在sql中只返回数字的第一个字符

Question

I am using code like this

$query = "SELECT Max(Vote) FROM VoteTab"; 
$result = mysqli_query($this->link,$query);
$query_data = mysqli_fetch_assoc($result);

foreach ($query_data as $record){
    $VoteCount=$record['Vote'];
    echo $VoteCount;
}

It returns value 5, but actual value is 56. If the value is 67 then it returns only 6. But it works fine for me in my localhost.

Id    Vote Name
1      23  Rohan
2      56  Vivek
3      32  Rahul
4      78  Broh
5      0   Tack
6      0   grey

Answer 1

mysqli_fetch_assoc() gets you one row of the result, which you then iterate with foreach, which is wrong. Correct code should be:

$query = "SELECT Max(Vote) FROM VoteTab"; 
$result = mysqli_query($this->link,$query);
$query_data = mysqli_fetch_assoc($result);
echo $query_data['Max(Vote)'];