今天刚在书上看过。。。写不来
<%
dim daycount
sql1="select * from visit where visit_name='"& session("username")&"'"
set rs=conn.execute (sql1)
if rs.eof or rs.bof then
sql1="insert into visit (visit_ip,visit_name,visit_count,visit_date) values ('"&request.ServerVariables("REMOTE_ADDR")&"','"&session("username")&"',1,date())"
'response.Write(sql1)
conn.execute sql1
else
'response.Write(rs("visit_count"))
sql1="update visit set visit_count=visit_count+1, visit_date=date() where visit_name='"&rs("visit_name")&"'"
conn.execute sql1
end if
sql1="select sum(visit_count) as counts from visit where visit_date=date()"
set rs=conn.execute (sql1)
daycount=rs("counts")
%>
日访问量,刚找的