Please cna someone help me.
I have a dating website and i want make it multilanguage.
I have one main table "members", when for example David register all information about David will be insert into "members". If David choose that his relationship_status is >Single<. The value for >Single< in registration form is >3< and
in table "members" 'relationship_status' of David will be >3<. I created the other table "relationship_status" where i defined multilanguage values for >3<. For example: in "relationship_status" i have three columns => >>lang<<, >>relationship_status<< and >>relationship_status_value<< in column >>lang<< i have en and fr, relationship_status column is 1 for en and fr, and in relationship_status_value i write "single" for en and "simple" for fr language (that means single in french).
Now, i can not make a sql query to display information for David on php page so that visitor with en language browser can se "SINGLE" for David but visitor with fr language browsers can se "SIMPLE" for David.
I know that i must make some join for this two tables, but i do not know how. PLEASE ANIONE HELP ME!?
