% dim fengcai,suixiang,yanjiu,xiaojisql,shehui,subject,xm1,xm2,xm3,xm4,xm5,s
randomize timer
s=Int((8999)*Rnd +990)
pic="select * from lianjie order by id"
set picrs=conn.execute(pic)
type2="select * from type order by id "
set typers=conn.execute(type2)
fengcai="select top 5 * from desktop where typeid=1 order by time desc"
suixiang="select top 5 * from desktop where zhuanti=0 and typeid=2 order by time desc"
yanjiu="select top 5 * from desktop where zhuanti=0 and typeid=3 order by time desc"
shehui="select top 5 * from desktop where zhuanti=0 and typeid=4 order by time desc"
xiaojisql="select * from desktop where zhuanti=1 order by time desc"
set xiaojirs=conn.execute(xiaojisql)
set fengcairs=conn.execute(fengcai)
set suixiangrs=conn.execute(suixiang)
set yanjiurs=conn.execute(yanjiu)
set shehuirs=conn.execute(shehui)
set rs=server.createobject("adodb.recordset")
rs.open "select * from vote",conn,1,1
subject=rs("subject")
xm1=rs("xm1")
xm2=rs("xm2")
xm3=rs("xm3")
xm4=rs("xm4")
%>