How can i translate multiple words from English to amharic and vise versa?

Question

I want to develop a dictionary that translates from egnlish to amharic and amharic to english. i am using sql server database and vb.net programing language.
create table mytable( id number unique, englishwords varchar2(100), amharicwords varchar2(100));
let me insert some values.
insert into mytable values(1, 'well', 'turu');
insert into mytable values(2,'come','na');
insert into mytable values(3,'you', 'ante');
insert into mytable values(4, 'are', 'nachew');
then if i want to know the meaning of english word 'well' in amharic,
i just type it in the textbox then i will get its corresponding meaning in amharic that is 'turu'.
but now my problem is ,if i write multiple words at the same time,
for instance, well come, then i expect to see the meaning of this that is 'turu na'. so how can i do this?
your help is crucial!

Answer 1

select amharicwords from mytable where englishwords == "well";

OR..

select amharicwords from mytable where id == '1';

depends on how your text box sends the variable to whatever script you're running..

Answer 2

English To Amharic Translation Dictionary

Answer 3

That response would provide only a 1 word response. He is looking for multiple.. This is probably not the best way to do this, but it should work

First set up a breif script that splits the words (like explode in php), then run them as 2 queries and rejoin them..

This exact code is probalby not going to work, I use mysql, not sql.. Besides this isn't right for either, but you will get the idea hopefully

select amharicwords from mytable where englishwords == "$word1";
Set the value if $word1 as the returned result
$word1 = .row['englishwords'];

select amharicwords from mytable where englishwords == "$word2";
Set the value if $word2 as the returned result
$word2 = .row['englishwords'];

echo $word1;
echo $word2:

Like I said, This is probably not the best way to do this, but it might help you find a better one..
You may want to look into joining tables..

Answer 4

English has an official status here in the Philippines.. But it depends largely on someones upbringing and education.. Filipinos are educated in English.. So basically the higher the education the better the English.. Poor Filipinos will know very little.. and will only really know their local dialect.. Where as Ive found working professionals speak it pretty much like a native English speaker... Where as maids,.. will only speak their local dialect. Guards and drivers will know a little more.. Workers in SM, Ace Hardware, etc... know a little more.. Philippines and India only places in Asia with good English...

Answer 5

Go to your seach engine and type in TRANSLATIONS. It will take you to several excellent sites that translate many languages for free and some others for a slight fee. Hope this helps!!!

This is the site I use: http://www.freetranslation.com/

If this helps please vote for me as BEST ANSWER, thank you.