<!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;
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;
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;
形如 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
select max(field) from table group by field_x
结果就是不对
共有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法查出来的
不对
下面的记录是用条条比对法比出来的
是正确的
总的记录包括以下四个部分
<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