MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 31st, 2003, 03:31 AM
mackole mackole is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2003
Posts: 1 mackole User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
PHP and MySQL

I do not know if this is the right place to ask the question,
but I do not know where else to post it.

I made a MySQL database with an English word, and its Dutch and Spanish translation.
For each word there is some additional information stored, such as which article is
used etc.

Now I want to make a searchscript with PHP, but I do not know where to start.
I want to make a drop down list where users can choose:
English --> Dutch
English --> Spanish
Spanish --> English
etc.

And of course an textfield where users can enter the word they are searching for.
As a result I want all the information for the specific output language, but of course not the rest of the information
stored in the database.
Does any one know if this is possible? And where I can find examples or so?

Thank you!

Reply With Quote
  #2  
Old March 31st, 2003, 07:14 PM
rickwright rickwright is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2003
Location: Nova Scotia
Posts: 27 rickwright User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I don't know your programming capability; but I'll start with this,

First set up a form that asks for the language to translate from and the language to translate to. Then ask for the word the user wants translatated.

When the user submits the form you run a query something like:

" SELECT $TranslateTo FROM TranslationsTable
WHERE $translate_from = '$word'";
For instance:

"SELECT Spanish FROM TranslateTable WHERE English = 'Soup'";

You would then use normal php methods to print the results

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > PHP and MySQL


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway