Multilingual site

[eluser]Sanjib Kumar Jena[/eluser]
Hi All,
I am developing a eCommerce site using Codeignitor. But my problem is this site should be multilingual. Actually i have no idea how to built a multilingual site. I came across some tutorials and examples. According to them i have to create a language file for each language in application/languages folder. This is ok, but what about the database records. I have given an admin panel to the client, he will enter data for the website. How to translate them to different languages. Or we will store records in database for each language. If so then how will be the database structure.
Please anyone help me in the above regards.

Thanks in advance.
Sanjib

[eluser]DarkManX[/eluser]
well, you can set different columns for languages like body_en, body_fr etc or you can create a column lang or something which will link a certain row to a certain language. first method will reduce your database rows to a minimum, but doesnt looks as good as the second method.