有懂SQL语句的帮金光整个法子

聶十八

哦用了count(*)
9 H# s/ I7 x0 s0 g" y; o+ D% B  l没用group by

haney

文盲飘过

ftw

这个很难清出来吧？

三叶草

试试我QQ群里发的，

金光

select author, count(*) from pre_forum_post_2 as b where b.fid='105' and b.tid='863265' and first=0 and mod(( select count(*) as dd from pre_forum_post_2 as a where a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) ,25)=0 group by author
3 g: [; O0 m  W% `& Q
) \( P* j/ K4 q% U' N' I' C6 _6 Eselect ( select count(*) as dd from pre_forum_post_2 as a where  a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) as xuhao, author  from pre_forum_post_2 as b where b.fid='105' and b.tid='863265' and first=0 and mod(( select count(*) as dd from pre_forum_post_2 as a where  a.fid='105' and a.tid='863265' and a.pid<b.pid order by pid) ,25)=0
' L& U$ G1 x2 o8 ]这个是显示发帖的楼层数
  x% M- V' e9 W; T