Hello all,
I'm planning to create an web-based glossary (actually Spanish<>English
glossary of retail banking terminology, so my buddies and I can
collaboratively prepare to interpret at a conference in a few months).
I'll be using either Perl/DBI or PHP, the only languages I speak.
Is there anyone out there who has done an online dictionary or glossary
and can share some tips about the data model and techniques? I know this
wheel has been invented before (yes I checked the archives; someone
mentioned he's done one but that's all he says).
At the very crudest, I can envision a table such as this
CREATE TABLE english_terms (
id smallint(5) unsigned NOT NULL auto_increment,
term varchar(255) DEFAULT '' NOT NULL,
translation text DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);
If you wanted to look up a term, your application might say
SELECT translation FROM english_terms WHERE term = 'usurious'
and so on. I can envision offering the user the option of searching for a
term that "is", "begins with", or "contains" what they type into a
textfield.
But again, I wonder if anyone has any advice.
TIA!
David Mintz
Spanish Interpreter
US District Court, Southern District of New York
Web Design & Hosting http://www.dmintzweb.com/
Personal http://www.panix.com/~dmintz/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php