Bear in mind that I've never attempted a multilingual website, 
but the first thought that I had when I read your post was to 
have a table name extension that gets appended based on the 
user's language choice/locale/whatever:

$langext = "_en";    // english
// $langext = "_de"; // german
// $langext = "_fr"; // french etc.

$sql = "
SELECT
*.*
FROM 
dropdownitem".$langext."

";

All other things being equal this way, you'd have 
duplicated tables but little else in your app.

dropdownitem_en
dropdownitem_de
dropdownitem_fr

categories_en
categories_de
categories_fr

If you have the ability to make the entire db this way,
(create database yourapp_en, yourapp_de, yourapp_fr, etc.)
it may be simpler, but depends on your host... 
I know I cant create dbs, only tables in one db for the domain.

Good Luck!
Geoff

D> I have, for the first time, a website to do in several languages.
D> I'll do a variable replacement whereever needed, with several 
D> lang files (as
D> I've seen so many times in open source PHP applications)
D> the color of his object, he chooses RED
D> I will store RED,BLUE,GREEN,etc. in a table 'color' so I can build a
D> dropdown list for the user to choose from
D> 
D> well now, if a visitor browse the ads in french. I'd like the 
D> color to read
D> 'rouge' not 'red'.
D> 
D> How should I go about that, database items ?


---------------------------------------------------------------------
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

Reply via email to