如何显示数据库表中某一列的三个最大数字

How to dispaly the three biggest numbers of one of the columns of a database table?

本文关键字：一列三个数字显示何显示数据库 | 更新日期: 2023-09-26

我必须编写一个php脚本来查找数据库表中列的三个最大数字。这是目前为止我的代码，但它不起作用。

<?php
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("pool");
 $res1=mysql_query("SELECT * FROM buy ORDER BY value LIMIT 3 ");
 while($r1=mysql_fetch_array($res1)){
     echo $r1['value']; 
  }
?>

SELECT * FROM `buy` ORDER BY `value` DESC LIMIT 3