While trying to figure out how to fix the count problem, I came across this.
I changed...
Code:
$sql_q = mysql_query("select search_text, search_count from search_queries_sorted order by " .
$HTTP_POST_VARS['sortorder'] . " " . $HTTP_POST_VARS['ascdsc']);
to
Code:
$sql_q = mysql_query("select search_text, search_count+1 from search_queries_sorted order by " .
$HTTP_POST_VARS['sortorder'] . " " . $HTTP_POST_VARS['ascdsc']);
...which should have fixed the problem.
However, the results are blank.
I tried running the query manually via phpMyAdmin and it works fine.
Anyone have any ideas what could be causing the problem?