如果不考虑性能,只要一条语句就好了 select b.id,count(a.id) as count from bbslist as a left join user as b on a.userid=b.id group by b.id order by count desc
select a.id, a.name , count(b.id) as num from user a left join bbslist b on b.userid=a.id group by b.userid order by num desc
$sql="select a.id, a.name , count(b.id) as num from user a left join bbslist b on b.userid=a.id group by b.userid order by num desc"; $r=mysql_query($sql); while($row=mysql_fetch_assoc($r)){ echo $row['name'] .'------------' . $row['num'] .'篇<br>'; }
select b.id,count(a.id) as count from bbslist as a left join user as b on a.userid=b.id group by b.id order by count desc
$r=mysql_query($sql);
while($row=mysql_fetch_assoc($r)){
echo $row['name'] .'------------' . $row['num'] .'篇<br>';
}