Multi language product table
Hi all,
I near to build a new complex website with a multilanguage products catalogue.
I'm using PHP+MYSQL.
Previously, with ADDT I was using the Many-to-Many server behaviour to manage the products table/languages is a single update/insert form.
What is the best approach to create a multilanguage catalogue with php+mysql + data assist?
I have 3 tables:
- products
- prod-lang
- lang
The prod-lang table contains the product foreign key, the lang foreign key and other fields for product description.
When I was using the many-to-many server behaviour in a product insert/update form some extra fields were created on the fly:
- checkbox for lang1, field1_lang1, field2_lang1, field3_lang1...
- checkbox for lang2, field1_lang2, field2_lang2, field3_lang2...
For every checked checkboxe above, a new record was added to the prod-lang table.
How can I do this with WA DB?
Or better, is there a better way to manage a multilanguage product catalogue/website?
TIA
tony