get count from each word

[kenny873]

if I have a file (result.txt) that contains :

egg
apple
egg
orange
banana
"chinese word"
"italian word"
"chinese word"

and I would like to count the frequecy of each term, do you know how? because I have a site provide search, every keyword search is stored in a table and now I would like to see which word is most frequent requested.

do I need to use trim() or other functions also to remove the white space and double quote?

thank you.

[dta]

this should help

$results=file("results.txt");

function mostFrequent($arr){
	$resArr=array();
	for($x=0;$x<count($arr);$x++){
		$word=preg_replace("/(\"|')*/","",trim($arr[$x]));
		$resArr[$word]=0;
		for($a=0;$a<count($arr);$a++){
			$word2=preg_replace("/(\"|')*/","",trim($arr[$a]));
			if($word2==$word){
				$resArr[$word]++;
			}
		}
	}
	arsort($resArr);
	return $resArr;
}
$arr=mostFrequent($results);
foreach ($arr as $k=>$v)
	echo "Term: $k -> $v hits<br>";

results.txt is exactly like you had it.
its still buggy/basic. should work pretty good though

-r