Then use the some variable in ur language files. That is templated
language elements that could hold variable in them.
e.g.
The article {ARTICLE_SUBJECT} was successfuly deleted !
It's dynamic now!
On Mon, 18 Oct 2004 09:10:35 -0200, Bruno B B Magalhães
<brunobbm@xxxxxxxxxx> wrote:
> 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
>
>
--
M.Saleh.E.G
97150-4779817
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
