Silver

Thanks for the replies. Let me be more specific about what I want to achieve. I want a multi-language website (English, French, Chinese, etc.). The drop-down menu of products (figure 8.4) should be in English for the English page, in French for the French page, etc. Do I need a separate products table in French, another table in Chinese? The suggested additional columns per languages could be a good solution, though I have not tried it yet. Is there a more professional way of doing this?

Products fetched from tables are in English (e.g. drop down menu of Fig. 8.4). In addition to getting them in English, how to get same results in other languages? Do we have to make a different identical table per language, or there is a script that translate the fetched products into other languages? Pls. share such a script, or any other method to achieve this goal.