/**
* Retrieve the top 20 search terms by popularity from the search_stats table
* Enter description here ...
*/
function getTopSearches()
{
require_once ROOT_DIR . '/Drivers/marmot_inc/SearchStatNew.php';
$numSearchesToReturn = isset($_REQUEST['numResults']) ? $_REQUEST['numResults'] : 20;
$searchStats = new SearchStatNew();
$searchStats->query("SELECT phrase, numSearches as numTotalSearches FROM `search_stats_new` where phrase != '' order by numTotalSearches DESC LIMIT " . $numSearchesToReturn);
$searches = array();
while ($searchStats->fetch()) {
$searches[] = $searchStats->phrase;
}
return $searches;
}
