Hello,
I got a website where i can receive and answer the question of the members. Everithing work except the mail notification. The members are supposed to receive a mail notification when i answer to them but instead of that i’m the one (the administrator) receiving it on my email address . If someone can find where the pb is it will be greatly appreciated.
<? if($_SESSION['auth']=='yes'){ $db = mysql_connect('xxx', 'xxx', 'xxxx') or die('Erreur de connexion '.mysql_error()); mysql_select_db('xxxx',$db) or die('Erreur de selection '.mysql_error()); $sql = "SELECT * FROM requete WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'"; $req = mysql_query($sql) or die('Erreur SQL !'.$sql.'
'.mysql_error()); while($data = mysql_fetch_assoc($req)){ $message= $_POST['message']; $message= nl2br($message); if($data['id_sender']==$_SESSION['id'] || $_SESSION['adm']=="yes"){ if($_SESSION['adm']=='yes'){ $sql = "INSERT INTO requete(id,id_ticket,message,type,etat,date,id_sender,sujet,date_last_modif,adm) VALUES('','".$_GET['id_ticket']."','".$message."','','',NOW(),'".$data['id_sender']."','','','".$_SESSION['id']."')"; }else{ $sql = "INSERT INTO requete(id,id_ticket,message,type,etat,date,id_sender,sujet,date_last_modif,adm) VALUES('','".$_GET['id_ticket']."','".$message."','','',NOW(),'".$_SESSION['id']."','','','')"; } mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error()); if($_SESSION['adm']=='yes'){ $sql = "UPDATE requete SET date_last_modif=NOW(),etat=2 WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'"; }else{ $sql = "UPDATE requete SET date_last_modif=NOW(),etat=1 WHERE id_ticket='".$_GET['id_ticket']."' AND master='1'"; } mysql_query($sql) or die('Erreur SQL !
'.$sql.'
'.mysql_error()); if($_SESSION['adm']=='yes'){ $sql1 = "SELECT nom,prenom,mail FROM users WHERE id='".$_SESSION['id']."'"; $req1 = mysql_query($sql1) or die('Erreur SQL !
'.$sql1.'
'.mysql_error()); while($data1 = mysql_fetch_assoc($req1)){ mail_entete("Bonjour ".$data['prenom']." ".$data['nom'].",\n \n contenu du mail ","libelle du mail","2",$data1['mail']); } }else{ mail_entete("Un nouveau message d'un utilisateur à été envoyé\n Contenu:$message","NOUVEAU MESSAGE ","1",""); } print"
Votre message a bien été envoyé!
; } } }else{ $error_mess = "Vous avez été déconnecté!"; include("connection.php"); } ?>