<%@ Language=VBScript %> Website Statistics <% Dim ThreeMonths, DateFrom, DateTo ThreeMonths = DateAdd("d", -30, Date()) DateFrom = request.form("datefrom") if DateFrom = "" then DateFrom = ThreeMonths else end if DateTo = request.form("dateto") if DateTo = "" then DateTo = Date() else end if %>
Query Visits: through

Visits ( <% response.write DateFrom %> through <% response.write DateTo %> ) <% 'include adoCon set rs=Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM Visitor WHERE VisitDate >= #" & DateFrom & "# AND VisitDate <= #" & DateTo & "# ORDER BY ID Desc" rs.Open SQL, adoCon %> <% Do while Not rs.EOF %> <% if rs("IP") < "17" or rs("IP") <> "unknown" then %> <% else %> <% end if %> <% rs.MoveNext() Loop %>
ID Date Time IP Page Referrer
<% = rs("ID")%> <% = rs("VisitDate")%> <% = rs("VisitTime")%> "><% = rs("IP")%> "> > <% = rs("IP")%> <% = rs("Page")%> "><% = rs("Referer")%>
<% rs.close set rs=nothing adoCon.close set adoCon=nothing %>