求助,各位大师,帮忙修改成按月统计,我是菜鸟,详细点,谢谢各位大师!
求助,各位大师,帮忙修改成按月统计,我是菜鸟,详细点,谢谢各位大师!(自动按月统计,显示在主网站上)<td align="center" height="38" class="MenuFont1">稿件排行</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" bgcolor="#CCCCCC" cellpadding="0" style="margin-bottom:15px;">
<%
sql = "select top 10 * from bigclass where m_ppppid = 68 order by m_num"
rs.open sql,db,1,1
while not rs.eof
sqll = "select * from newslist where n_bigclassid ="&rs("m_id")&" and n_time between #2012-06-01 00:00:00# and #2012-07-01 00:00:00#"
rss.open sqll,db,1,1
%>
<tr>
<td align="center" width="60%" bgcolor="#FFFFFF"><%=rs("m_title")%></td>
<td align="center" bgcolor="#FFFFFF"><%=rss.recordcount%>篇</td>
</tr>
<%
rss.close
rs.moveNext
wend
rs.close
%>
</table></td>