
08/07/2009, 08:26
|
 | | | Fecha de Ingreso: septiembre-2006 Ubicación: Rosario - Santa Fe
Mensajes: 296
Antigüedad: 18 años, 6 meses Puntos: 8 | |
Respuesta: funcion mail no me manda el html Código PHP: <?PHP
include('conexion.php');
conectar();
$sql="SELECT event_log.*, event_def.subject FROM event_log, event_def WHERE status = 0 AND event_def.event = event_log.event"; $res=mysql_query($sql);
$headers = "MIME-Version: 1.0\r\n Content-type: text/html; charset=iso-8859-1\r\n From: Opus<[email protected]>\r\n";
while ($event_log = mysql_fetch_array($res)) {
if ($event_log[id_from] != $event_log[id_to]) { if (is_null($event_log[id_to])) { $query="SELECT event_mail.* FROM event_mail, event_def WHERE event_mail.event = '".$event_log[event]."' and event_def.profil = 0 AND event_def.event = event_mail.event ";//si no le hago el filtro por event_def.profil = 0 se lo manda a todos los analistas //echo $query; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { //echo "<br><br>entre<br><br>"; $dameElMail = "SELECT name, email_work FROM members WHERE id =".$row[id_member]; $r = mysql_query($dameElMail); $losDatos = mysql_fetch_array($r); /////////////////armo el mail if ($losDatos[email_work]!="") { $to = $losDatos[email_work]; $subject = $event_log[subject]; $message = $event_log[description]; mail($to, $subject, $message,$headers); } /////////////////fin armo mail } } else { $quer="SELECT * FROM event_mail WHERE event = '".$event_log[event]."' AND id_member = ".$event_log[id_to]; $re=mysql_query($quer); while($rowi=mysql_fetch_array($re)) { $dameElMail = "SELECT name,email_work FROM members WHERE id =".$rowi[id_member]; $rr = mysql_query($dameElMail); $losDato = mysql_fetch_array($rr); /////////////////armo el mail if ($losDato[email_work]!="") { $to = $losDato[email_work]; $subject = $event_log[subject]; $message = $event_log[description]; mail($to, $subject, $message,$headers); } /////////////////fin armo mail } }
}
//actualizo el estado de los eventos para que en la proxima consulta //no elija los eventos que elegio en esta consulta $y="update event_log set status = 1 WHERE id = ".$event_log[id]; mysql_query($y); } desconectar();
?> gracias! |