如何不显示最大和最小？

Question

我想显示所有价格，但不显示最大和最小价格。

我正在使用 NOT IN 但它不起作用。

<?php $cod_product = $_GET["cod_product"];

$sql = "SELECT `ppm`
                ,`price`
                ,`market`
                ,`product`
                ,`name_market`
                ,`cod_market`
    FROM ppm, markets
                WHERE product=$cod_product AND cod_market=market NOT IN (SELECT MAX(price), MIN(price) FROM ppm)
                ORDER BY price ASC";

        $result = mysql_query($sql, $connection) or die("fail");

        if ($dados = mysql_fetch_array($result)) {
            do {

                $cod_market = $dados['market']; 
                $nome_mercado = $dados['name_market'];
                $price = $dados['price'];



             echo $price;
            echo $name_market;


            }
            while($dados = mysql_fetch_array($result));
            }else { }
            ?>

Answer 1

将 mini() 更改为 min()（假设是 MySQL）。

mini() 不是一个函数。

另外，你的一些 SQL 没有多大意义。

  SELECT cod_ppm
         ,price
         ,market
         ,product
    FROM ppm
   WHERE price NOT IN (SELECT MAX(price), MIN(price) FROM ppm)
ORDER BY price ASC