PHP/MySQL MIN不能返回正确的价格 - PHP/MySQL MIN doesn't return correct price

PHP/MySQL MIN doesn't return correct price

本文关键字：返回 MySQL MIN 不能 PHP | 更新日期: 2023-09-27

在我的mysql表中有"auction"answers"price"的值

像这样:

auction | price
1       |   22  
55      |   789
55      |   333 
55      |   666

我需要选择拍卖的最低价格55.

55最低价是333。我使用这个mysql查询:

$re = mysql_query("SELECT MIN(amount) as amount FROM `bids` WHERE auction = '".$id."'");
$r = mysql_fetch_assoc($re);
echo $r['amount'];

但是它返回789(第一个条目，但不是最低的)，为什么?

您需要GROUP BY auction .

mysql_query("SELECT MIN(price) as amount FROM `bids` GROUP MY auction WHERE auction = '".$id."'");

试试下面的代码:

$re = mysql_query("SELECT MIN(amount) as amount FROM `bids`");
$r = mysql_fetch_assoc($re);
echo $r['amount'];