<% page=clng(request("page")) Set rs=Server.CreateObject("Adodb.RecordSet") if username <>"" then sql="select vuser,count(*) from [count] where vuser='"& username &"' and vdate like '*"& year &"-"& month &"*' group by vuser"
else sql="select vuser,count(*) from [count] where vdate like '*"& year &"-"& month &"*' group by vuser order by count(*) desc"
end if response.write(sql) rs.open sql,conn,1,3 rs.pagesize=20 if page<1 then page=1 if page>rs.pagecount then page=rs.pagecount if rs.pagecount>0 then rs.absolutepage=page myself=request.serverVariables("PATH_INFO") response.write("111111") for i=1 to rs.pagesize response.write("2222222") if rs.eof then exit for response.write("333333") %>