Displaying "Most Popular Pages" on the Index Page

[leeannM]

I am trying to figure out how to display the "top ten" most visited pages on my site as an ongoing automatically fed display. Is this impossible to do?
Thank you,
leeann

[Ribeyed]

hi,
yes and straight forward to do. I would add something like this code to every page in the site:


DateTimeEntrance = year(date) &_
left("00",2-len(month(date))) & month(date) &_
left("00",2-len(day(date))) & day(date)
DateTimeEntrance = DateTimeEntrance & " " & time()
DBConn.Execute "insert into tblPageViews (RecordID, PageVisited, WhenVisited) values (" _
& Session("SessionID") & ", 'Home Page', '" & DateTimeEntrance & "')"


The all you need is a simple SQL statement to pull out the top 3 visited pages.

Hope this helps