$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 (" ERROR: ".mysql_error()."");
$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.'
';
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 "Sorry, but we can not find an entry to match: ".stripslashes($trimmed)." in $format2";
echo "Did you mean:".$rows[0]."?";