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