复制代码 代码如下:
$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 dnum 
        from `cy_score2` 
        where (nei='下载' or nei='下载试题')   
        group by uid having dnum>150 
        order 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.uid 
        group by b.uid 
        order by a.dnum desc,unum asc limit 5; 
$query4=mysql_query($sql3); 
$rs=mysql_fetch_array($query4) ;
http://www.bkjia.com/phpjc/326488.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/326488.htmltecharticle复制代码 代码如下: $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,coun...