|
|
发表于 2010 年 11 月 22 日 11:46:58
|
显示全部楼层
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
5 \9 g% b7 t; N+ K3 }! e6 H2 G' ^* |2 Q8 i5 B' D' T; _6 H$ N
select ( 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- z) `! [! E* F& s9 X- }- Q8 w
这个是显示发帖的楼层数
) i; `, x; S, g0 D2 H3 _8 T5 E |
|
IP卡
狗仔卡
显身卡
发表于 2010 年 11 月 22 日 10:22:18
发表于 2010 年 11 月 22 日 11:00:04
