I know this is a bit dusty, but looking at the code,
$search_db->select_options ('ORDER BY Results DESC', 'LIMIT 5');
This would return the 5 keywords with the most "hits" rather than the most commonly searched terms. In the searchlogger 2.1 you'd want to 'ORDER BY HitCount DESC' to find the terms people are searching on the most.
BTW: I rewrote the SearchLogger to use different logic (it's probably a bit slower than Alex's version, but it does more), and to also track the daily keywords. I need to finish the Top_xx tags code and I can release it. I'm trying to figure out how to do this without having to have the user install the globals manually (I think alex gave some code to do that awhile back, but I haven't found it yet).
PUGDOG� Enterprises, Inc.
The best way to contact me is to NOT use Email.
Please leave a PM here.
$search_db->select_options ('ORDER BY Results DESC', 'LIMIT 5');
This would return the 5 keywords with the most "hits" rather than the most commonly searched terms. In the searchlogger 2.1 you'd want to 'ORDER BY HitCount DESC' to find the terms people are searching on the most.
BTW: I rewrote the SearchLogger to use different logic (it's probably a bit slower than Alex's version, but it does more), and to also track the daily keywords. I need to finish the Top_xx tags code and I can release it. I'm trying to figure out how to do this without having to have the user install the globals manually (I think alex gave some code to do that awhile back, but I haven't found it yet).
PUGDOG� Enterprises, Inc.
The best way to contact me is to NOT use Email.
Please leave a PM here.
