Most Viewed Pages - How?

Results 1 to 2 of 2

Thread: Most Viewed Pages - How?

  1. #1
    Rob W Guest

    Default Most Viewed Pages - How?

    Does anyone know of an article that explains how to create a dynamic list of the "most viewed pages" of a web site. 4GuysFromRolla has an example of this on their site. How do they do that? Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Most Viewed Pages - How?

    That, unfortunately, is done by hand. However, on our dedicated server we are keeping track of each time an article is read (via a DB), and then getting the TOP N instances of:<BR><BR>SELECT ArticleName, URL FROM Articles<BR>ORDER BY TimesRead<BR><BR>the syntax is:<BR><BR>SELECT TOP 10 ArticleName, URL<BR>FROM Articles<BR>ORDER BY TimesRead DESC<BR><BR>Hope this helps!<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •