Hi,

I do have a flat file with all the translations for the interface and everything, but the problem is de dynamic content that must be multilingual...

Regards,
Bruno

On Oct 18, 2004, at 5:29 AM, M Saleh EG wrote:

I'd always preffer to keep language stuff in files instead of DB.

A question or a problem u might face later is: How are you going to
store the text in the proper Charset in ur tables?

I'd do it this way.
-A field in DB to keep the current default language
-Every module in the app should have it's own language pack
-Write a set of routines to read my language files and return the right values.


With DB-Method u gotta hit a trip to ur database for every element or
every language pack.


Try checking phpMyAdmins way of managing language or any other application to get inspired.

On Sun, 17 Oct 2004 23:23:03 -0300, bruno b b magalhaes
<[EMAIL PROTECTED]> wrote:
Hi everone,

I am building a multilingual content management systen, and I am studying the best way
to have the content translated, with minimal Database queries and load.


So I have:

CONTENTS
contentId
contentCreationDate
contentModificationDate
translationId
contentStatus

CATEGORIES
categoryId
categoryParentId
categoryModulePath
translationId
categoryStatus

TRANSLATIONS
translationId
field01
field02
field03
field04
field05
field06
field07
field08
field09
field10
translationLanguage
translationStatus

So just run a simple join query:
SELECT contents.*,translations.* FROM contents,translations WHERE
contents.translationId=translations.translationId AND
translations.translationLanguage='en-uk' AND translations.translationStatus = 1


Or with categories:
SELECT categories.*,translations.* FROM categories,translations WHERE
categories.translationId=translations.translationId AND
translations.translationLanguage='en-uk' AND translations.translationStatus = 1 AND
categories.categoryModulePath='products'


Any better idea to handle that?

Regards,
Bruno B B Magalhaes

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
M.Saleh.E.G
97150-4779817


-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to