Nevermind...
I figured it out this way:
//Referring page possible keyword values
$possiblekeywords = ARRAY(
"ask",
"keyword",
"Keywords",
"p",
"q",
"qry",
"qt",
"qu",
"query",
"s",
"search",
"string",
"su",
"text"
);
$totalsearchterms = querydatabase("SELECT Referrer, COUNT(Referrer) as todsearchterms FROM stats WHERE Referrer LIKE '%search%' GROUP BY Referrer ORDER BY todsearchterms DESC, Referrer LIMIT $limit;");
while ($myrow = mysql_fetch_array($totalsearchterms)) {
$searchterm = ARRAY($myrow[Referrer]);
foreach ($searchterm AS $searchterms) {
$searchwords = parse_url($searchterms);
$queryvalue = $searchwords["query"];
foreach ($possiblekeywords AS $keywords) {
if (preg_match("/\b$keywords\b/i", $queryvalue)) {
parse_str($queryvalue, $query);
$queriedwords = $query[$keywords];
echo "<b>$queriedwords</b>";
}
}
}
echo " $myrow[todsearchterms]<br>";
}
