I have a form, which has 3 kind of user input -> English , Hindi, tamil
Now i am using separate table for each language, based on user selection form displays and he can fill the form in his regional language.
The only problem is now i want:
i have 3 tables which have 3 different lnaguages data like: english, hindi and tamil.
Now i want to provide app admin a link, using which he can get raw dump data of all 3 tables but in english only. Means converting data stored in hindi and marathi fonts on fly (i guess) to english and dump whole data in single 1 excel sheet. is it possible ?
so database will be storing regional language
that's why we have 3 different tables
i want to have a 4th table, where all record of 3 table is dumped
when user goto a url or somekind of button he use
while dumping 3 tables
sql and php should convert 2 different languages to english as well
and store all 3 tables data in english language
into 4th temp table
then i will provide user an interface where user can dump all data from that 4th table to excel sheet.
Fair bids only please. no more than 30$