$query3 = $mysql->query("SELECT * FROM ".$mysql->pref2."_notification WHERE message_id='$id'"); $rs = mysql_query($query3) or die ("Erreur de syntaxe !"); $nbrenreg = mysql_num_rows($rs); $cpt=1; if ($nbrenreg>0){ $auto = mysql_result($query3,0,"auto"); while($row = mysql_fetch_array($rs)){ if(!empty($notification) && $pseudo2['pseudo'] == null ){ $emailquery = $mysql->query("SELECT * FROM ".$mysql->pref2."_membres WHERE pseudo='$pseudo'"); $email = mysql_result($emailquery,0,"mail"); $mysql->query("INSERT INTO ".$mysql->pref2."_notification (id, message_id, pseudo, titre, mail) VALUES('', '$id', '$pseudo', '$titre', '$email')");} else{ $mysql->query("DELETE FROM ".$mysql->pref2."_notification WHERE pseudo='$pseudo' AND titre='$titre'"); } } }