Search for synonyms

[Chinese]

Hey,

at first I really like your board, imho it's fairly better than the german boards.

Yes I'm from germany 

so i got a question.

I developed a search engine and now im trying to find a solution, how im also able to find synonyms.

Thats why i made a table with this syntax

 id | word | synonym
1 | car | 1
2 | automobile | 1
3 | 05 | 3
4 | 5 | 3

(just an example - the german one would be better, because i dont speak english-slang well)

If i search "automobile" the result should include the results of "car", too - logical.

But that's not a problem with this code.

if ($search = trim($_GET['q'])) {
  	if (!get_magic_quotes_gpc()) $search= addslashes($search);
    if (strlen($search) > 50) die('Interrogation too long');
     
    require('verbindung.php');
    
    $synonymquery = " SELECT word
                        FROM `synonyme`
                        WHERE wort != '$search[0]'
                        AND (
                              synonym = (
                                SELECT synonym
                                FROM synonyme
                                WHERE wort = '$search[0]' )
                              OR id = (
                                SELECT synonym
                                FROM synonyme
                                    WHERE word = '$search' )
                              OR synonym = (
                                SELECT id
                                FROM synonyme
                                WHERE word = '$search[0]' )
                        )";                    
    
  	$result = mysql_query($synonymquery);

    while ($suche = mysql_fetch_array($result) or die (mysql_error())) {

    // rest of the search

    }
}

 

Now my question:

If i search two synonyms at once, it doesnt work. In this case "automobile 5" would be such a search-term.

I thought at a foreach-loop, but the foreach-loop would search for "automobile" and then for "5" and not for "autombile 5".

 

I hope youll get the sense.

 

Would you be so kind to help me? 

 

thanks and best wishes from germany,

Chinese