Localizing Bilingual Site

Hi, I am a bit new to PHPRunner and I am trying to find a way to choose the display language based on the current session Language... PLEASE NOTE - I have tried and can get the recommended system of having 2 rows for every item with the language type at the end. However, this causes a some problems based on some of what we are trying to accomplish when it comes to bilingual reports and stats that need to be generated.
Here is what I am trying to do.

Data
ID Code Descp_ENG Descp_FR

1 01 Red Rouge

2 02 Yellow Jaune
I was working with a basic IF Then MYSQL Statement (or a CASE statement) That I was hoping to setup through the Lookup Wizard as a custom field display, but I am having no luck... perhaps I need to add the coding in another location?
Second question related... I noticed in my testing that the session language does not appeared to be passed on from the LOGIN screen. I have actually change the language in the site once I have logged on to it in order to get it to properly pass adjust the language display, even with the recommended coding of a separate row in each table for each language. Is there a code I need to add to push that session language forward?
I am working with PHPRunner 7.1
Thanks for any help.