php - 尝试检索最小值时出现 mysql "select"问题

Question

这个问题已经有答案了:

mysql min where statement (1 个回答)

已关闭 5 年前。

我的数据库中有几行以下数据:

 name    price
 iphone  1000
 iphone  888
 iphone  1010

我试图为 iPhone 获取最便宜的价格，但我的脚本返回最昂贵的价格

class getdbdata {

    function cheapestprice($nameofproduct) {

        $servername = "localhost";
        $username = "username";
        $password = "password";
        $dbname = "mobilephones";
        $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, 
        $password);
        $sql = ("SELECT name,price  FROM phones where name like 
        '%".$nameofproduct."%' and  price =(SELECT MIN(price) FROM phones)");  
        $stmt = $pdo->prepare($sql);
        $stmt->execute() ;
        $posts= $stmt->fetch() ;
            foreach ($posts as $post ) {
        echo $post;
            }
            var_dump($posts);   
    }

}

$getdbdata = new getdbdata();
$getdbdata->cheapestprice("iphone");

Answer 1

将查询更改为:

SELECT name, Min(price) FROM phones where name like '%".$nameofproduct."%'