All pastes #565331 Raw Edit

Stuff

public php v1 · immutable
·published 2007-06-13 23:36 UTC
rendered paste body
	$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_array($result)) { 		$compare = $row[term];		$levenshtein = levenshtein($trimmed, $compare);		$lengthdifference = max($trimmed, $compare) - min($trimmed, $compare);		$levenshtein-=$lengthdifference;		$similarity = $levenshtein/strlen(min($trimmed, $compare));		$row['similarity'] = $similarity; $rows[] = $row;						print_r($rows);		}						function levsort($a, $b)			{			    { if ($a['similarity'] > $b['similarity']) return 1; else return -1; }			}			usort($rows, "levsort");