<% '数据库连接未写,请自己写代码 '周排行程序开始 Set rswh= Server.CreateObject ("ADODB.RecordSet") sqlwh = "select * from flashzpin where id="&id rswh.open sqlwh,conn,3,3 sunday=rswh("sunday") 'sunday 数据库子段显示星期天的日期 if date()-sunday<=7 then sqlweek="update flashzpin set weekhit=weekhit+1 where id="&id 'weekhit为周点击次数 set rshit=conn.execute(sqlweek)
else '否则周点击为1, 也就说从1开始重新累计 sqlweek="update flashzpin set weekhit=1,sunday=date()-weekday(date())+1 where id="&id set rshit=conn.execute(sqlweek)