ho fatto cosi,ma non invia email:
che ne dici?? grazieCodice PHP:$user_id = array();
$sSQL = "SELECT id FROM ".PREFIX."users";
$result = mysql_query($sSQL);
while($row= mysql_fetch_row($result))
{
$user_id[] = $row['id'];
}
for($i= 0; $i < sizeof($user_id); $i++)
{
$sSQL = "SELECT p.id,p.owner,p.orderID,p.title,p.dateadded,u.email,u.firstname,u.lastname FROM ".PREFIX."listings AS p INNER JOIN ".PREFIX."users AS u ON p.owner=u.id AND display='Y' WHERE u.id=" . $user_id[$i];
$result=$db->query($sSQL);
$rs=$result->fetch();
$id=$rs['id'];
$to=$rs['email'];
$vars['title']=$title;
$vars['firstname']=$rs['firstname'];
$vars['lastname']=$rs['lastname'];
$content="tuoreport_report.tpl";
$msg=$Mailer->sendMail($to, $content,$vars);

Rispondi quotando