Q:

Php and Mysql multi-lingual pages

I'm new in PHP  I've made a MVC framework after some tutorial and I really learn a lot. I know with a built-in framework like Zend I've could done this easy I think. So what i want to do next is to  build a multilingual site. For start will be only to languages like  Romanian and English. 
The problem that I've got is that i will have an option from witch users can  add  new pages to the site after a review of one of the admins, here the base language will be Romanian. So There will be a text at least of 200 words and there could be as many pages as database can keep. SO There should be something like an automatic translation, but this is not good enough thinking this will be a presentation site.
I have looked into tutorials and examples on this but id cannot fine some solution to fix my problem. My pages content will be generated from database. After some wrong solution I have thought to a solution to keep in the db only some id instead of a word/phrase and to that id to correspond some id's from translation table. This is not a good option thinking that there will be no good for adaptation from one language to another.
Can you give me some solution for this? Or can you give me some good tutorials/ examples to map to my problem?
Thank you

A:

I would just show English content to people who use the site in English and Romanian content for those using it in Romanian. If I use the site in English and go to your profile I'll see all of your articles even those in Romanian. But when I browse though latest, popular ... I only see those in English.
Database structure :
Language table
language_id | language_name | langauge_code
-------------------------------------------
     1      |    English    |      en
     2      |     Român     |      ro
     3      |    Spanish    |      es

Post table
post_id | user_id | language_id | post_title | post_content
------------------------------------------------------------
   23   |    7    |      2      |     ...    |     ...
   24   |    5    |      1      |     ...    |     ...

If you really want a translation for everything add a third table, then you would have original language, with options : also availible in Romanian, author : John Doe,  translator : Jane Doe ...
Translation table
trans_id | post_id | user_id | language_id | post_title | post_content
----------------------------------------------------------------------
    4    |    23   |    4    |      1      |     ...    |     ...
    5    |    23   |    5    |      3      |     ...    |     ...

You can't worry too much about translations, I would just translate static content (header, footer, navigation, buttons...), let users post in what ever language they want, if you have comments on your site they will be in lots of languages. Other sites don't worry about it (facebook, twitter, ...).
You may also want to look into .po and .mo files with gettext, you can generate translation files which you can use with Poedit
Hope this helps.

