Re: Solution for multi-lingual application with the same content

On Thu, 2009-12-10 at 03:09 -0800, dev wrote:
> I need solution for multi-lingual application where are galleries,
> product's categories and product list.
>
> Let's say i create gallery, product's categories and products in
> primary language and i need to translate them in second language, but
> with the same gallery images, product categories and products. I don't
> want to upload the same images to gallery, create the same products
> and so on, just in another language.
>
> What solution would be best for this? I want to translate these items
> in my custom cms, not .po files.

If you have a lot of products and product list tend to change there
would be better to have this DB structure:

PRODUCT (id, name, desc, other properties in main language).
PRODUCT_$LANG (id, product_id, name, desc, other text properties in
whatever language you want).

And to get translated values, you just join these tables.

--
Regards,
Giedrius Rekasius

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en