Ok, I have made a decent content management website now setup in dutch with MySQL backend.
The company I'm programming the website for wants it to be in several languages:
dutch, english, german, french, spanish, catalan
So that's 6 languages.
For the static texts that are in between the script that aint much of a problem. I just make 6 language files. This won't take that much.
But for the database-data, which covers a lot eg.:
- news
- links
- productcategories
- products
- jobs
- customers
- administrators
I can only think of making extra fields in the database, so when a field is for english it will be named something like: description_en, when dutch: description_dut
Something like that. Also, in the adminpart of the website the admin should be able to fill those fields,.. so instead of a product having 4 inputfields, it will need 6x4=24 fields, which makes a huge form.
I could make different adminforms, so for each language one.. but that would it all make much to complex. It ain't IBM or another huge company...
I need suggestions on what would be the best way to do it without doing loads and loads of reprogramming.
Any ideas....?
