php max()查出来的不是最大值

$result1 = mysql_query("SELECT valpc ,MAX(valpc) as valpc FROM intoput WHERE nampc LIKE '$getnamfrq' ")hile($row = mysql_fetch_array($result1)){
$maxok=$row["valpc"];
}
结果是 99XXX
好象不是大最值

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

$getnamfrq变量的值是怎么样的，如果不包含通配符，那你这个查询的条件相当于WHERE `nampc` = '$getnamfrq'。
你没有结合group by当然不管用了
select max(field) from table group by field_x
max是用来在你给条件或者group by出来的数据中的最大的那个值，而不是整个表的，上面说的有点问题，单单是group by，只要是你取出来的数据都可以，但是max只会作用到你取出来的数据中
其实我只要找出VALPC的最大值和最小值
结果就是不对
查询价格为：284.49
共有1398个相关的价格记录。其中最高993.60元，最低为993.60元。主要价格区间为 - 平均值为：284.49元每箱。四个数据来源中有四个数据库有相关价格资料其中稽查相关数据有：215条记录;检务相关数据有：1144条记录;海关相关数据有：0条记录！小商品价格库有：39条记录。
稽查数据库记录。共有 215条记录，平均价格为630.11元，最高为8 928.57元，最低为48.00元，主要价格区间为xx-yy元。
检务数据库记录。共有1144条记录，平均价格为228.49元，最高为24 007.75元，最低为0.05元，主要价格区间为0.15-0.33元。
海关数据库记录。共有0条记录，平均价格为0.00元，最高为0.00元，最低为0.00元，主要价格区间为bb-cc元。
小商品指数记录。共有39条记录，平均价格为21.90元，最高为102.00元，最低为0.13元，主要价格区间为dd-ee元。总的记录是用MAX MIN法查出来的
不对
下面的记录是用条条比对法比出来的
是正确的
总的记录包括以下四个部分
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>
<body>
<?php$con = mysql_connect("localhost","root","122609louis");if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }$ccds=$_GET["pp"];
$getnamfrq= iconv("gb2312","UTF-8",$ccds);$gethsfrq=$_GET["qq"];
$getjqueorn=$_GET["oo"];mysql_select_db("jsp_db", $con);
if($getjqueorn==0){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%'  ") or die(mysql_error());
$result1 = mysql_query("SELECT MAX(valpc) as valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' group by  valpc ") or die(mysql_error());
$result2 = mysql_query("SELECT  MIN(valpc) as valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' group by  valpc ") or die(mysql_error());}
else if ($getjqueorn==1){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq'  ") or die(mysql_error());
$result1 = mysql_query("SELECT  MAX(valpc) as valpc FROM intoput WHERE nampc LIKE '$getnamfrq' group by  valpc ") or die(mysql_error());
$result2 = mysql_query("SELECT  MIN(valpc) as valpc FROM intoput WHERE nampc LIKE '$getnamfrq' group by  valpc ") or die(mysql_error());}
else
{
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%'  ") or die(mysql_error());
$result1 = mysql_query("SELECT MAX(valpc)  as valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' group by  valpc ") or die(mysql_error());
$result2 = mysql_query("SELECT MIN(valpc) as valpc  FROM intoput WHERE nampc LIKE '%$getnamfrq%' group by  valpc") or die(mysql_error());}$nubok=0;
$zhiok=0;while($row = mysql_fetch_array($result1)){
$maxok=$row["valpc"];
}
while($row = mysql_fetch_array($result2)){
$mixok=$row["valpc"];
}
while($row = mysql_fetch_array($result)){
$nubok=$nubok+1;

$zhiok=$zhiok+ $row["valpc"];

}
if($nubok!=0){
$pjzhiok=$zhiok/$nubok
;}
else{ $pjzhiok=0;
$maxok=0;
$mixok=0;}
echo "<div id='ttlsaid' class='ttlsaid'>";
  echo"<div class='bgcolor005' id='jgdivpriceban'>";
    echo"<p> </p>";
   echo" <p>查询价格为：</p>";

    echo"<div class='bgcolor006' id='prpjttl'>";

    echo"<p class='bgcolor006'>";
echo number_format($pjzhiok,   2,   ". ",   " "); echo"</p> </div> </div>";

  echo"<div class='bgcolor007' id='prqkmaoshu'>";
    echo"<p> </p>";
    echo"<p>共有";
echo $nubok;
echo"个相关的价格记录。</p><p>其中最高"; echo number_format($maxok,   2,   ". ",   " ");
echo"元，最低为";
echo number_format($mixok,   2,   ". ",   " ");
mysql_close($con); echo"元。主要价格区间为";

echo" ";
echo"-";
echo" ";
echo"平均值为：";
echo number_format($pjzhiok,   2,   ". ",   " ");
echo"元每箱。</p><p>四个数据来源中有四个数据库有相关价格资料</p><p>其中稽查相关数据有：";$con = mysql_connect("localhost","root","122609louis");if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("jsp_db", $con);
if($getjqueorn==0){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND (resonim  LIKE  '稽查原有数据对接'or resonim like '巡查日常输入')");}
else if ($getjqueorn==1){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' AND (resonim  LIKE  '稽查原有数据对接'or resonim like '巡查日常输入')");}
else
{
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND (resonim  LIKE  '稽查原有数据对接'or resonim like '巡查日常输入')");}$nuboka=0;
$zhioka=0;
$maxoka=0;
$mixoka=1000000;
$temoka=0;
while($row = mysql_fetch_array($result)){
$nuboka=$nuboka+1;

$zhioka=$zhioka+ $row["valpc"];

$temoka=$row["valpc"];
if($maxoka<$temoka){$maxoka=$temoka;};if($mixoka>$temoka){$mixoka=$temoka;};
}if($nuboka!=0){
$pjzhioka=$zhioka/$nuboka;
echo $nuboka;
echo"条记录;";}
else{
echo"0条记录！";
$pjzhioka=0;
$maxoka=0;
$mixoka=0;}
mysql_close($con);

echo"检务相关数据有：";
$con = mysql_connect("localhost","root","122609louis");if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("jsp_db", $con);
if($getjqueorn==0){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE  '检务数据资料对接'");}
else if ($getjqueorn==1){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' AND resonim  LIKE  '检务数据资料对接'");}
else
{
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE  '检务数据资料对接'");}$nubokb=0;
$zhiokb=0;
$maxokb=0;
$mixokb=1000000;
$temokb=0;
while($row = mysql_fetch_array($result)){
$nubokb=$nubokb+1;

$zhiokb=$zhiokb+ $row["valpc"];

$temokb=$row["valpc"];
if($maxokb<$temokb){$maxokb=$temokb;};if($mixokb>$temokb){$mixokb=$temokb;};
}if($nubokb!=0){
$pjzhiokb=$zhiokb/$nubokb;
echo $nubokb;
echo"条记录;";}
else{
echo"0条记录！";
$pjzhiokb=0;
$maxokb=0;
$mixokb=0;}
mysql_close($con);
echo"海关相关数据有：";
$con = mysql_connect("localhost","root","122609louis");if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("jsp_db", $con);
if($getjqueorn==0){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE  '海关资料数据对接'");}
else if ($getjqueorn==1){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' AND resonim  LIKE  '海关资料数据对接'");}
else
{
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE  '海关资料数据对接'");}$nubok3=0;
$zhiok3=0;
$maxok3=0;
$mixok3=1000000;
$temok3=0;
while($row = @mysql_fetch_array($result)){
$nubok3=$nubok3+1;
$zhiok3=$zhiok3+ $row["valpc"];
$temok3=$row["valpc"];
if($maxok3<$temok3){$maxok3=$temok3;};if($mixok3>$temok3){$mixok3=$temok3;};
}
if($nubok3!=0){
$pjzhiok3=$zhiok3/$nubok3;
echo $nubok3;
echo"条记录;";}
else{
echo"0条记录！";
$pjzhiok3=0;
$maxok3=0;
$mixok3=0;}

mysql_close($con); echo "</p><p>小商品价格库有：";
$con = mysql_connect("localhost","root","122609louis");if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }mysql_select_db("jsp_db", $con);
if($getjqueorn==0){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE   '小商品数据库对接'");}
else if ($getjqueorn==1){
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' AND resonim  LIKE   '小商品数据库对接'");}
else
{
$result = mysql_query("SELECT valpc FROM intoput WHERE nampc LIKE '%$getnamfrq%' AND resonim  LIKE   '小商品数据库对接'");}$nubok4=0;
$zhiok4=0;
$maxok4=0;
$mixok4=1000000;
$temok4=0;
while($row = mysql_fetch_array($result)){
$nubok4=$nubok4+1;

$zhiok4=$zhiok4+ $row["valpc"];

$temok4=$row["valpc"];
if($maxok4<$temok4){$maxok4=$temok4;};if($mixok4>$temok4){$mixok4=$temok4;};
}if($nubok4!=0){
$pjzhiok4=$zhiok4/$nubok4;
echo $nubok4;
echo"条记录。";}
else{
echo"0条记录！";
$pjzhiok4=0;
$maxok4=0;
$mixok4=0;}
mysql_close($con); echo"</p>";
  echo"</div></div> <div class='bgcolor008' id='prdb01'><div class='bgcolor009' id='NB001'></div><div class='bgcolor010' id='prdb001'><p> </p><p  class='p1'>稽查数据库记录。</p><p>共有
  ";
  echo $nuboka;
  echo"条记录，平均价格为";
  echo number_format($pjzhioka,   2,   ". ",   " ");
  echo"元，最高为";
  echo number_format($maxoka,   2,   ". ",   " ");
  echo"元，最低为";
  echo number_format($mixoka,   2,   ". ",   " ");
  echo"元，主要价格区间为";
  echo"xx";
  echo"-";
  echo"yy";
  echo"元。</p></div></div><div class='bgcolor018' id='prdb02'><div class='bgcolor019' id='NB002'></div>
  <div class='bgcolor020' id='prdb002'><p> </p>
  <p  class='p2'>检务数据库记录。</p><p>共有";

  echo $nubokb;
  echo"条记录，平均价格为";
  echo number_format($pjzhiokb,   2,   ". ",   " ");
  echo"元，最高为";
  echo number_format($maxokb,   2,   ". ",   " ");
  echo"元，最低为";
  echo number_format($mixokb,   2,   ". ",   " ");
  echo"元，主要价格区间为";
  echo"0.15";
  echo"-";
  echo"0.33";


  echo"元。</p></div></div><div class='bgcolor028' id='prdb03'><div class='bgcolor029' id='NB003'></div>
  <div class='bgcolor030' id='prdb003'><p> </p>
    <p class='p3'>海关数据库记录。</p><p>共有";

echo $nubok3;
  echo"条记录，平均价格为";
  echo number_format($pjzhiok3,   2,   ". ",   " ");
  echo"元，最高为";
  echo number_format($maxok3,   2,   ". ",   " ");
  echo"元，最低为";
  echo number_format($mixok3,   2,   ". ",   " ");
  echo"元，主要价格区间为";
  echo"bb";
  echo"-";
  echo"cc";
echo"元。</p></div></div><div class='bgcolor038' id='prdb04'><div class='bgcolor039' id='NB004'></div>
  <div class='bgcolor040' id='prdb004'><p> </p>
<p class='p4'>小商品指数记录。</p><p>共有";

echo $nubok4;
  echo"条记录，平均价格为";
  echo number_format($pjzhiok4,   2,   ". ",   " ");
  echo"元，最高为";
  echo number_format($maxok4,   2,   ". ",   " ");
  echo"元，最低为";
  echo number_format($mixok4,   2,   ". ",   " ");
  echo"元，主要价格区间为";
  echo"dd";
  echo"-";
  echo"ee";

echo"元。</p></div></div>";
  ?>
</body>
</html>
形如
SELECT MAX(valpc) as valpc FROM intoput WHERE nampc LIKE '$getnamfrq' group by valpc
SELECT MIN(valpc) as valpc FROM intoput WHERE nampc LIKE '$getnamfrq' group by valpc
这样的语句都是错误的！
你对 valpc 取最大值，就不能对 valpc 分组
应去掉 group by valpc其实你这样写更好
最大值
SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' order by valpc desc limit1
最小值
SELECT valpc FROM intoput WHERE nampc LIKE '$getnamfrq' order by valpc limit 1