博客发表排行
作者:cmscn 日期:2009-09-02
<table border=0 width='100%'>
<%
sql="select top 5 author,count(id) as num from blog_data group by author order by count(1) desc,author"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
response.write vbcrlf&" <tr><td>"&rs("author")&"</a> ("&rs("num")&")</td></tr>"