how to display an item from a db depending on whether the language is English or French?

[eluser]saby[/eluser]
In a database, i have a table with 2 columns: title_fr & title_en
how to display the title depending on whether the language is English or French?

Do i need to keep the lang in session object?
if yes, how to do ?

Thanks