Just assuming I understand what you are after, I think it would be much faster and easier to write a few RewriteRule expressions in Apache (/etc/httpd/conf/httpd.conf) and then use a log parser to count up how many hits come from which URLs.
On Mon, Aug 9, 2010 at 5:46 PM, Jason King <[email protected]> wrote: > Thanks Matt.. > > In my stupidity of not being able to visualize how to do this.. I had > another idea. > > Rather than keeping the full http_referer in the database, split it > into two columns.. That way I would only have to parse the referer > once, and any future queries would be straight on without having to do > any crazy loops? > > referer_host > referer_string > > aka.. a referer of > > http://forums.anandtech.com/showthread.php?t=2096389 > > would be kept as > > referer_host - forums.anandtech.com > referer_string - showthread.php?t=2096389 > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > official manual: http://www.openbluedragon.org/manual/ > Ready2Run CFML http://www.openbluedragon.org/openbdjam/ > > mailing list - http://groups.google.com/group/openbd?hl=en > -- Colin -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
