Untitled

	$sql = "SELECT DISTINCT term FROM logs WHERE term_soundex LIKE LEFT(SOUNDEX('$trimmed'),4) AND results2 >0 AND term REGEXP '[0-9]' !=1 LIMIT 10";
 	$result = mysql_query($sql) or die ("<center> ERROR: ".mysql_error()."</center>");
	
	$rows = array();
	while ($row = mysql_fetch_assoc	($result)) { 
		$compare = $row[term];
		$levenshtein = levenshtein($trimmed, $compare);
		$lengthdifference = max($trimmed, $compare) - min($trimmed, $compare);
		$levenshtein-=$lengthdifference;
		$similarity = $levenshtein/strlen(min($trimmed, $compare)) * 100;

		$row['similarity'] = $similarity;

                // just to check
                echo $similarity.'<br>';
       
                if(!is_array($rows[$similarity])){
                       $rows[$similarity] = array();
                }

                $rows[$similarity][] = $row;

		//	$rows2[] = $rows;

		}
// print before sorting
print_r($rows);

	ksort($rows,SORT_NUMERIC);

//	foreach($rows as $key=>$value){ echo $key.'###'.$value;}
//	if($rows === false) echo "It's false!";
//	else echo "No";
//	var_dump ( $rows );
	print_r($rows);

	
   echo "<font color='#333333' size='2' face='Arial, Helvetica, sans-serif'><center>Sorry, but we can not find an entry to match: <b>".stripslashes($trimmed)."</b> in <b>$format2</b></center></font>";
		echo "<font color='#333333' size='2' face='Arial, Helvetica, sans-serif'><center>Did you mean:<a href='search.php?search=". $rows[0]."&format=all&page=1'>".$rows[0]."</a>?<center></font>";