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 <brunobbm.rlk@xxxxxxxxxxxx> 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
