php - 最大功能不工作

Question

我有这张表:

 fistname      | lastname     |  english 
--------------------------------------------- 
bob           | wilson       | 77  
jess          | farr         | 47 

这是我在 php 中的代码:

    $con = mysql_connect('localhost','root','');    
mysql_select_db('education');
$highest= mysql_query("SELECT firstname, lastname, max(english)FROM students");
$row = mysql_fetch_row($highest);
echo 'English Highscore:' ;
echo "\r\n" ;
echo $row[0];
echo '&nbsp';
echo $row[1];

它会将 jess 显示为得分最高的那个而不是 bob:

Answer 1

试试这个:

$highest= mysql_query("SELECT firstname, lastname, english FROM students order by english DESC limit 1");