Database and languages...

[Anon]

Hi y'all

I'm having a hard time deciding what's the best way to implement a multi-language product information system...

Let me xplain:
I'm building a site that has to be at least bilingual. In this site, I want to showcase some products, depending on their categories.

So basically should I create 2 distinct databases with mySQL (one for each language), or create a table called for example "words" that would contain all the words depending on the language you choose...

please help!!!!

[zone16]

I think the easiest is to add a language table that would look like this
id language
1 English
2 French

Then you would add all your table an language_id so that you do need duplication(and a logistical nightmare when you make a change)

table : word
word language_id
Hello 1
Bonjour 2

hope this is what you're looking for,

zone16