dictionary translation linked to translation
Posted: Sun Jul 29, 2007 12:55 pm
I have two dictionary databases:
1.) lithuanian - english
2.) english - lithuanian
I need for e.g. if I see some translation "lithuanian - english":
`labas - hello, greeting word`
to check if there arent some words from explanation avayble in "english - lithuanian" dictonary if there is:
`labas - <a href="#word_id">hello</a>, greeting <a href="#word_id">word</a>`.
Here is how do I display curent word:
and dabase structure is wery simple:
anglulietuviu:
lietuviuanglu:
-------------------------------------------------------
I think we are talking about day and night. I will try to explain once again my problem. I have two tables in my database: terms_engtolt (id, term, translation), terms_lttoeng (id, term, translation). I need that when client is viewing translation from terms_engtolt, every word of it (each word from translation) would be checked for TERM matches from terms_ltoeng if there are any matches word from translation should be replaced to link to the translatio for the matched term.
Do you understand now ?
1.) lithuanian - english
2.) english - lithuanian
I need for e.g. if I see some translation "lithuanian - english":
`labas - hello, greeting word`
to check if there arent some words from explanation avayble in "english - lithuanian" dictonary if there is:
`labas - <a href="#word_id">hello</a>, greeting <a href="#word_id">word</a>`.
Here is how do I display curent word:
Code: Select all
$mysql_db = new MySQL ("localhost", "root", "***", "dictionary");
$result = $mysql_db->query ("SELECT * FROM anglulietuviu WHERE id=$word_id");
$row = mysql_fetch_array($result);
echo "<strong>Word</strong> ".$row['word']."<br />";
echo "<strong>Translation</strong> <span id=\"".$row['id']."\">".$row['translation']."</span><br />";anglulietuviu:
Code: Select all
id, word, traslationCode: Select all
id, word, traslationI think we are talking about day and night. I will try to explain once again my problem. I have two tables in my database: terms_engtolt (id, term, translation), terms_lttoeng (id, term, translation). I need that when client is viewing translation from terms_engtolt, every word of it (each word from translation) would be checked for TERM matches from terms_ltoeng if there are any matches word from translation should be replaced to link to the translatio for the matched term.
Do you understand now ?