Hello;
On my news-website, I have mad it so that everytime someone enters a search string, it is added to the database.
What I wish to do is order the top x search strings on a page.
Can anyone help? It would be much appreciated.
"select count(*) as count, searchstring_name from table_name group by searchstring_name order by count DESC LIMIT XX"
count - will be the number of times the query has been used searchstring_name - the query XX - set this to number of results you want to grab (ie top 100)
