What Have You Done For Me Lately?
12 Jun 2002I 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.