You need to make the BSQL 'DBSQL' and you need to do the same in the use DBSQL line.

The smiley faces are a real pain... and should not appear in the code blocks, but they do.

I've also figured out how to count daily search term hits, and keep a running total for each day, and I'm working on a way to log the results, so that once a day is over, the program looks to see if the summary exists, if it does, it uses that, if not it calculates it, then stores the summary so that future searches don't have to re-generate it.

This solved a much larger problem for me, and has implications for my "Top 10" links, "Top Today" and "Yesterday" etc. Look for the release soon. If anyone _needs_ this now in beta code, drop me an email. You are on your own for how to install it, but if you want the beta code, you should know how to do that. Once it's all done, the subroutines could be cloned and modified to do just about any sort of tracking and "top" lists you would want. It's just a munge from jump.cgi and search.cgi but it's a useful one!