注册 登录
编程论坛 ASP技术论坛

求助,各位大师,帮忙修改成按月统计,我是菜鸟,详细点,谢谢各位大师!

gzas999 发布于 2012-12-21 09:53, 439 次点击
求助,各位大师,帮忙修改成按月统计,我是菜鸟,详细点,谢谢各位大师!(自动按月统计,显示在主网站上)

<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>
3 回复
#2
ysf01812012-12-21 13:00
sql = "select top 10 * from bigclass where m_ppppid = 68 order by m_num desc"
#3
gzas9992012-12-21 13:47
麻烦2楼的老师,能不能详细一点,因为我是菜鸟,麻烦了,谢谢!
#4
hu9jj2012-12-21 17:25
加一个年月的字段(如YYYYMM),然后直接对表按月汇总可能会更方便些。
1