Multi-language functionality

[minds_gifts]

Hello,
Did anybody of you has implemented multi-language functionality to your webpages??well, i did long time back using interbase as the database and stored-procedures.I store all the language phrases in a table and get them every time i change the language.
I would like to implement it now using mysql.Can anybody suggest me a nice tutorial/useful information.
Thanks in advance

[Wurzel]

i don't know what you did with interbase but i do it with mysql like that:

id|text|menuid|.....|lang
1|blabla|1|...|de <= for german
2|blabla|1|...|en <= for english

i use the specification for the meta-information about the site language. so if you wanna change the language, just save a cookie or a session with the lang which was chosen by the user.

[MelloPie]

I did a multilanguage supporting page and considered the way you mentioned, but came to the conclusion that storing everything in the database might slow down the performance.
So I stored all language related stuff in files which are included based on the chosen language.

[Wurzel]

i'm mixing it. the variable textinformation (=> CMS) is stored in the database, the static information i store in php-files like "en.lang.php", etc.