All pastes #98436 Raw Edit

Developpez

public text v1 · immutable
#98436 ·published 2006-07-24 14:44 UTC
rendered paste body
$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'");
                                  
                                  } 
				  
				   }