Send a different template if EN our FR

[beegees]

Hello,

I would like to know if its possible to send a different email template if a session variable is "FR" our "EN" ?

I would like to send the email template in frech if the visitor is french and in engilsh if the visitor is English (or other).

This is what I did but I have an error :

if($_SESSION['langue']=="FR")
			{
				$cfg_id=2;
			}
			elseif($_SESSION['langue']=="SP")
			{
				$cfg_id=3;
			}
			else
			{
				$cfg_id=1; //db_input($cfg->getId())
			}
			
            $sql='SELECT ticket_reply_subj,ticket_reply_body FROM '.EMAIL_TEMPLATE_TABLE.
                ' WHERE cfg_id= '.$cfg_id.' AND tpl_id='.db_input($tplId);

in my database, I have 3 templates (cfg_id 1, 2 and 3).

The templates 2 and 3 are in state "not in-use" is it normal ?

How can I activate them ?

Thank you in advance for your help.

beegees