I have been storing the referer URLs in MySQL. Now I want to run a query that identifies the search engines and search terms. I want to count the hits from each search engine and rank them in a report.
Does anybody know of a good chunk of code for parsing the URL's and seperating the TLD from the key words? Am I going to need an array of seach engine names and their TLD's (top level domains)?
