dictionary translation linked to translation

spamyboy

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:

$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 />";

and dabase structure is wery simple:
anglulietuviu:

id, word, traslation

lietuviuanglu:

id, word, traslation

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 ?

halojoy

yes.

you need a query that takes word by word from row in terms_engtolt
and search for it in terms_lttoeng table

where terms_engtolt is:
id - help me now - ytem mi nut

and terms_lttoeng is:
id - ytem mi nut - help me now

... and when found what to do??

... and where do the 2 tables:
id, word, translation
... come in ???

spamyboy

halojoy wrote:
yes.

you need a query that takes word by word from row in terms_engtolt
and search for it in terms_lttoeng table

where terms_engtolt is:
id - help me now - ytem mi nut

and terms_lttoeng is:
id - ytem mi nut - help me now

... and when found what to do??

... and where do the 2 tables:
id, word, translation
... come in ???

... and when found [b]what to do??[/b]

replace matched word to same word just linked to translation.
for e.g.
there was eng to lt translation

Camp - stovyklaviete kur zmones gyvena.

and there was match from lttoeng: stovyklaviete, zmones.
so then it should replace translation to:

Camp - <a href=#id_retrieved_from_lttoeng>stovyklaviete</a> kur <a href=#id_retrieved_from_lttoeng>zmones</a> gyvena.

... and where do the 2 tables:
[b]id, word, translation[/b]
... come in ???

--
-- Database: `dictionary`
--

-- --------------------------------------------------------

--
-- Table structure for table `terms_engtolt`
--

CREATE TABLE `terms_engtolt` (
  `id` int(11) NOT NULL auto_increment,
  `term` varchar(255) NOT NULL,
  `translation` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `word` (`term`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27146 ;

-- --------------------------------------------------------

--
-- Table structure for table `terms_lttoeng`
--

CREATE TABLE `terms_lttoeng` (
  `id` int(11) NOT NULL auto_increment,
  `term` varchar(255) NOT NULL,
  `translation` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `word` (`term`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=361 ;

btw. here is working example of what I need from our concurents:

http://www.anglu-lietuviu.com

see how they show theyr translations.