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
