$sql = "select avg(value2) from (select id,value2 from tablename where id >= 20400 AND id < 21700 order by value1 desc limit 0,50) as a where id between 20600 and 20699";这样试试chinese这个在你的SQL里面没有出现
错误在你的SQL语句, <?php (连接数据库的代码省略) $sql = "select avg(value2) from (select id from tablename where id >= 20400 AND id < 21700 order by value1 desc limit 0,50) as a where id between 20600 and 20699"; $avg = mysql_query($sql); $result = mysql_fetch_array($avg); echo $result[0]; ?> 在你的临时表a中没有chinese字段,它只有id ,看(select id from tablename where id >= 20400 AND id < 21700 order by value1 desc limit 0,50) as a 所以当然会报错了!而且是找不到chinese.
不是说了吗
你在phpmyadmin里面试下
上次漏了value2了...
<?php
(连接数据库的代码省略)
$sql = "select avg(value2) from (select id from tablename where id >= 20400 AND id < 21700 order by value1 desc limit 0,50) as a where id between 20600 and 20699";
$avg = mysql_query($sql);
$result = mysql_fetch_array($avg);
echo $result[0];
?>
在你的临时表a中没有chinese字段,它只有id ,看(select id from tablename where id >= 20400 AND id < 21700 order by value1 desc limit 0,50) as a
所以当然会报错了!而且是找不到chinese.