I have a form in three different languages and store information on a single database. And I have search page that searches for data from database by selecting dropdown menus. But when user searches he gets results only in language he is using. I need to show results from all languages according the users selection. How can I achieve this goal? Any idea and help is appreciated.
More details from comments:
It is a site that trainers register and students search for Trainers. When trainer registers he fills the form and also selects for example the Sector from dropdown menu. And site has 3 version in different languages. And when student searches for a trainer he selects a Sector and I want to show all results related to the selected sector regardless of the language Trainer registered and the user uses.
I have a data table as following
// Table : data
// --------------------------------------------
// username | name | sector_id | lang
// --------------------------------------------
// jack | Jack | 1 | en
// --------------------------------------------
// smith | Smith | 1 | fr
// --------------------------------------------
and Sector table as following
// Table : sector
// --------------------------------------------
// sector_id | sector_eng| sector_sp | sector_fr
// --------------------------------------------
// 1 | Finance | Financiar | la finance
// --------------------------------------------
For example, when user searches for sector Finance I need to get all data both for jack and smith but show la finance for Smith and finance for Jack in result