$query3 = $mysql->query("SELECT * FROM ".$mysql->pref2."_notification WHERE message_id='$id'"); $auto = mysql_result($query3,0,"auto"); while ( $pseudo2=mysql_fetch_array($query3)){ 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'"); } }