运用临时表查询数据（实际开发中遇到的解决）
$sql3="CREATE TEMPORARY TABLE atmp_table(uid int(11),dnum int(20) not null)";mysql_query($sql3);$sql3="INSERT into atmp_table(uid,dnum) SELECT uid,count(soid) as dnumFROM `cy_score2`where (nei='下载' or nei='下载试题') group by uid having dnum>150order by dnum desc limit 10";mysql_query($sql3);$sql3="select a.uid,count(b.tid) as unum from atmp_table a left join cy_test b on a.uid=b.uidgroup by b.uidorder by a.dnum desc,unum asc limit 5";$query4=mysql_query($sql3); $rs=mysql_fetch_array($query4)
