28,390
社区成员
发帖
与我相关
我的任务
分享
<!--#include file="conn.asp"-->
<%
Dim aa()
Dim bb()
a=1
set rs=server.createobject("adodb.recordset")
sql="SELECT [why],count(qx) AS NUM FROM cs GROUP BY [why]"
rs.open sql,conn,1,1
do until rs.eof
aa(a)="rs(0)"
bb(a)="rs(1)"
a=a+1
rs.movenext
loop
rs.close
%>
<%
dim total(4,1)‘“4”是我自己数的,不懂怎么通过数据库计算。
total(1,0)=aa(1)
total(2,0)=aa(2)
total(3,0)=aa(3)
total(4,0)=aa(4)
total(1,1)=bb(1)
total(2,1)=bb(2)
total(3,1)=bb(3)
total(4,0)=aa(4)
%>
<!--#include file="conn.asp"-->
<%
Dim rs,sql,i
set rs=server.createobject("adodb.recordset")
sql="SELECT id,filename FROM filelist"
rs.open sql,conn,3,1
ReDim total(rs.recordCount,1)
For i = 1 To rs.recordCount
total(i,0) = rs(0)
total(i,1) = rs(1)
rs.movenext
next
rs.close
%>
<!--#include file="conn.asp"-->
<%
Dim rs,sql,i
set rs=server.createobject("adodb.recordset")
sql="SELECT [why],count(qx) AS NUM FROM cs GROUP BY [why]"
rs.open sql,conn,3,1
Dim total(rs.recordCount,1)
For i = 1 To rs.recordCount
total(i,0) = rs(0)
total(i,1) = rs(1)
rs.movenext
loop
rs.close
%>