我想显示所有的价格,但不包括max和mini。
我正在使用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 { }
?>
将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