'今日发贴
myarray=split(formatdatetime(now(),2),"-",-1,1)
yy=myarray(0)
mm=myarray(1)
dd=myarray(2)
sqlstr="select count(id) as daytotal from bbstitle where year(dateh)='"&yy&"' and month(dateh)='"&mm&"' and day(dateh)='"&dd&"'"
set rs=conn1.execute(sqlstr)
daytotal=rs("daytotal")
rs.close
'昨日发贴
sqlstr="select count(id) as daytotal from bbstitle where year(dateh)='"&yy&"' and month(dateh)='"&mm&"' and day(dateh)='"&dd-1&"'"
set rs=conn1.execute(sqlstr)
zttotal=rs("daytotal")
rs.close
'最高日发贴
sqlstr="select count(id) as daytotal from bbstitle where year(dateh)='"&yy&"' and month(dateh)='"&mm&"' and day(dateh)='"&dd-1&"'"
set rs=conn1.execute(sqlstr)
zgtotal=rs("daytotal")
rs.close