首页社区监察局第一看守所

回复:10 浏览:1074

回帖排行、发帖排行代码共享
分享: 新浪 腾讯 空间 手腾
Rebs.
[楼主]:Rebs.
[在线]:2017-08-09 21:52:06
[职务]:
[勋章]:
[关注]:家园.空间.帖子.相册
发表时间:2015-07-13 00:08:13 我有话说(10人参与)

回帖统计排行怎么弄??
其实就是调用数据库语句:
这是回帖代码:


<%
Response.ContentType="application/xhtml+xml; charset=utf-8"
Response.write ""
Response.write ""
Response.write ""
Response.write ""
Response.write "ml; charset=utf-8""/>"
Response.write "回帖排行榜"
Response.write ""
Response.write ""
Response.write ""

Page_Login

Response.write"【回帖排行】
"
Dim NO
NO=0
Rs.Open "SELECT top 30 [uid],COUNT([uid]) AS nums FROM [wap_topic_reply] WHERE [status]=0 GROUP BY [uid] ORDER BY nums DESC",Conn
Do While Not Rs.Eof
NO=NO+1
Response.write NO&"."&UserName(Rs(0))&"
"
Rs.MoveNext
Loop
Rs.Close

Response.write "----------
"
Response.write "社区>政府>排行
"
%>


这是发帖排行:

<%
Response.ContentType="application/xhtml+xml; charset=utf-8"
Response.write ""
Response.write ""
Response.write ""
Response.write ""
Response.write "ml; charset=utf-8""/>"
Response.write "发帖排行榜"
Response.write ""
Response.write ""
Response.write ""

Page_Login

Response.write "【发帖排行】
"
Dim NO
NO=0
Rs.Open "SELECT top 30 [uid],COUNT([uid]) AS nums FROM [wap_topic] WHERE [status]=0 GROUP BY [uid] ORDER BY nums DESC",Conn
Do While Not Rs.Eof
NO=NO+1
Response.write NO&"."&UserName(Rs(0))&"
"
Rs.MoveNext
Loop
Rs.Close

Response.write "----------
"
Response.write "社区>政府>排行
"
%>


回贴列表(10)
10楼 发表时间:2016-08-29 03:10:48
回头
9楼 发表时间:2016-01-04 08:00:42
这地方真好
8楼 发表时间:2015-12-31 17:51:24
看看
回复该贴

首页社区监察局第一看守所