PapaScott I like big blogs and I cannot lie! 🐘

What Have You Done For Me Lately?

I just rearranged my referers page to sort chronologically, which seems to make more sense for a site with little traffic like this one. I'm still using Brent's code, but added a MAX(d) column to the SQL query, and sort on it:

SELECT DISTINCT url, COUNT(*) as ct, MAX(d) as maxd from referers GROUP BY url ORDER BY maxd DESC, url;

I could do some more intelligent things with the URLs (like sort out duplicates and highlight the really disturbing Google queries), but maybe another day.

comments powered by Disqus