vipin8vit

i am trying a search with levenshtein but m stuck with a serious problem.The field "topic" in the database is a string of more than one word which m not able to solve with the type of search i am doing here.had there been one word in the string it would be fine but for such case its a total failure. i also need to use the soundex() or some similar function as the entries in my database are no similar.and again one more problem php 4.4.2 that m using is case sensitive so levenshtein is not working fine. m totally stuck.please fix the code.here is the code ........................................................................... <?php // input misspelled word $trimmed=@$_GET['q']; $input=trim($trimmed); $arrWords=explode(" ",$input); if(sizeof($arrWords)==0||$input==""){ echo"enter keyword"; echo"<a href=\"lev.php\">click here</a>"; } $m=sizeof($arrWords); echo"nkdkf$m"; $shortest = -1; mysql_connect("localhost","root"); @mysql_select_db(test); //foreach ($arrWords as $trimm){ //$query1 = "SELECT topic FROM forum_question WHERE topic LIKE \"%$trimm%\" ORDER BY id DESC" ; $query1="select topic from forum_question"; $result1=mysql_query($query1); $i=0; $count=0; while($r=mysql_fetch_array($result1)){ $topic[$i]=$r["topic"]; //echo $topic,"\n"; //echo"<br>"; //$toopic=explode(" ",$topic); //$n=sizeof($toopic); //for($k=0;$k<$n;$k++){ //$toopic[$i][$k]=$toopic[$k]; //echo $toopic[$i][$k]; //} $i++; $count++; } //foreach ($topic as $word) { $i=0; for($i=0;$i<$m;$i++){ for($j=0;$j<9;$j++){ //for($k=0;$k<$n;$k++){ $lev = levenshtein($arrWords[$i], $topic[$j]); echo"$lev\n\n"; if ($lev == 0) { // closest word is this one (exact match) $closest = $topic[$j]; $shortest = 0; // break out of the loop; we've found an exact match break; } if ($lev <= $shortest || $shortest < 0) { // set the closest match, and shortest distance $closest = $topic[$j]; $shortest = $lev; } } echo "Input word: $arrWords[$i]\n"; if ($shortest == 0) { echo "Exact match found: $closest\n"; } else { echo "Did you mean: $closest?\n"; } $closest=""; $shortest=-1; } ?>