All pastes #566307 Raw Edit

Anonymous

public php v1 · immutable
·published 2007-06-14 12:15 UTC
rendered paste body
Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) [4] => Array ( [term] => bhddhism and judaism [similarity] => 0.7 ) ) Array ( [0] => Array ( [term] => buddhism and psychotherapy [similarity] => 0.730769230769 ) [1] => Array ( [term] => body scan relaxation [similarity] => 0.85 ) [2] => Array ( [term] => buddhism [similarity] => 0.125 ) [3] => Array ( [term] => Buddhism for Beginners [similarity] => 0.727272727273 ) [4] => Array ( [term] => bhddhism and judaism [similarity] => 0.7 ) [5] => Array ( [term] => Buddhism for Beginners: A Complete Course on the Heart of the Buddha's Teachings [similarity] => 0.925 ) )	$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));		$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");