WHILE VE WHILU VE FOREACH – PHP – Fórum – Programujte.com

Potřebuji $_POST['nazev'] porovnat s názvy ingredienci a to i kdyz se nebudou presne schodovat takze napriklad Mouka a mouka je to same nebo Borůvky a boruvky take jsou stejne. Proste kdyz zadane slovo je v databazi tak vypis do tabulky nazev z databaze.. Prosim o radu tento script je zde jen informacni je to asi 150 verze takze poznamky typu "proc to delas takhle nebo takhle" prosim nee.V souboru diakretika je jen pole s klicema na zmenseni.

Fulltextovy dotaz jsem zkopiroval potrebuji prochazen pouze nazvy ingredienci

 
                           foreach ( $_POST['nazev'] as $nazevingr )
                          {
                              $post =  $nazevingr;
                              $search = $post;
                              $prikaz =     mysql_query(" SELECT nazev FROM ingredience WHERE MATCH(nazev) AGAINST ('$search' IN BOOLEAN MODE) OR nazev LIKE '%$search%'
                                            ORDER BY 5 * MATCH(nazev) AGAINST ('$search') + MATCH(nazev) AGAINST ('$search')  DESC "); 
                              while($i = MySQL_Fetch_Array($prikaz,MYSQL_ASSOC))
                              {                                                                   
                                  $dbnazvy = $i['nazev'];
                                   include 'diakretika.php';
                                  $dbna = strtr('$dbnazvy', $TRANSLIT_TABLE);
                                  $dbna = strtolower($dbna);
                                   var_dump($dbnazvy);
                                  $nazevingr = strtr($nazevingr, $TRANSLIT_TABLE);  // zbaveni diakretiky a pismena s diakretikou zmensi
                                  $nazevingr = strtolower($nazevingr); // zmenseni pismen bez diakretiky
                                 
                               if($dbna==$nazevingr) 
                                  {
                                      $nazev[] = $i['nazev'];  
                                  }else
                                  {
                                      $nazev[] = $_POST['nazev'];
                                  }                                                                    
                              }
                         
                          }
                          }
                          // zjistena zda je ci neni ingredience jiz v databazi
                       
                                    $i=1;
                                    $iArray=0;
                                    $nazev=array();
                                    while ($i <= $pocetIngredienci)
                                    { 
                                   
                                      echo"<tr>
                                          <td>".$nazev [$iArray]."</td>
                                          <td>".$_POST['mnozstvi'][$iArray]."</td>
                                          <td>".$_POST['jednotka'][$iArray]."</td>
                                        </tr>";
                                        $i++;
                                        $iArray++;
                                    }