Envio por e-mail

olá a todos.

Preciso enviar e-mail para usuários conforme a cidade, exemplo: se tem 30 itens da cidade de São Paulo esta enviando 30 e-mails. Preciso que envie somente um e-mail com os 30 registros.

Veja o código que uso.

>

Citar

 <?php

 $sql2 = "SELECT cities.city_name,cities.slug,cities.state, places.city_id as cidade_id,places.place_id,places.place_name,places.description,places.submission_date,places.email,places.jobid,subscriptions.id as idj,subscriptions.email as mail,subscriptions.city_id,subscriptions.token,subscriptions.created,subscriptions.is_confirmed FROM cities, places,subscriptions WHERE  cities.city_id=places.city_id and places.city_id=subscriptions.city_id and places.status='approved' and subscriptions.is_confirmed=1 and subscriptions.id=1496 GROUP BY subscriptions.email limit 3 ";

 $ex2 = mysql_query($sql2) or die (mysql_error());

 //$x = 0;

 while ($row= mysql_fetch_array( $ex2 ) )

 {

     $id=$row['place_id'];

     $nome=$row['place_name'];

     $slug=toAscii($row['place_name']);

     $description= $row['description'];

     $cidade= $row['city_name'];

     $cityslug= toAscii($row['city_name']);

     $city_id= $row['cidade_id'];

     $data= $row['submission_date'];

     $place_id=$row['place_id'];

     //$contar=$row['contar'];

     $token=$row['token'];

     $email=$row['email'];

     $mail=$row['mail'];

     $idj=$row['idj'];

  

     

         $T1=$nome;

 $_SESSION['T1']= $T1;

 $T15=$slug;

 $_SESSION['T15']= $T15;

 $T4=$description;

 $_SESSION['T4']=$T4;

 $T5=$cidade;

 $_SESSION['T5']=$T5;

 $T16=$cityslug;

 $_SESSION['T6']=$T16;

 $T20=$city_id;

 $_SESSION['T20']=$T20;

 /*$T6=$cidade;

 $_SESSION['T6']=$T6;*/

  $T7=$place_id;

  $_SESSION['T7']=$T7;

  $T18=$contar;

  $_SESSION['T18']=$T18;

  $T9=date('d/m/Y',strtotime($data));

  $_SESSION['T9']=$T9;

  

  $T11=base64_encode($place_id);

  $_SESSION['T11']=$T11;

  $alert="alerta";

  $T31=base64_encode($alert);

  $_SESSION['T31']=$T31;

  

  $T14=base64_encode($email);

  $_SESSION['T14']=$T14;

  

  $T32=$email;

  $_SESSION['T32']=$T32;

      

         $email_text_select = mysql_fetch_array( mysql_query( "select * from emailtext_emp where et_code='news2'" ) );

             $adminemail="noreplay@site.net";

             $webname="site";

             $to=$mail;

             $js_id=$idj;

             $message_text="";

             $message_text = $email_text_select['et_details'];

             $message_text = str_replace( "%nome%", $nome, $message_text );

             $message_text = str_replace( "%js_id%", $js_id, $message_text );

             $message_text = str_replace( "%token%", $token, $message_text );

             $message_text = str_replace( "%T1%", $T1, $message_text );

             $message_text = str_replace( "%T4%", $T4, $message_text );

             $message_text = str_replace( "%T5%", $T5, $message_text );

             $message_text = str_replace( "%T7%", $T7, $message_text );

             $message_text = str_replace( "%T6%", $T6, $message_text );

             $message_text = str_replace( "%T8%", $T8, $message_text );

             $message_text = str_replace( "%T9%", $T9, $message_text );

             $message_text = str_replace( "%T10%", $T10, $message_text );

             $message_text = str_replace( "%T11%", $T11, $message_text );

             $message_text = str_replace( "%T14%", $T14, $message_text );

             $message_text = str_replace( "%T15%", $T15, $message_text );

             $message_text = str_replace( "%T16%", $T16, $message_text );

             $message_text = str_replace( "%T18%", $T18, $message_text );

             $message_text = str_replace( "%T20%", $T20, $message_text );

             $message_text = str_replace( "%T31%", $T31, $message_text );

             $message_text = str_replace( "%T32%", $T32, $message_text );

             $message_text = str_replace( "%webname%", $webname, $message_text );

             $message = "{$message_text}";

             $subject = "Novas vagas em $T5";//$email_text_select['et_subject'];

             $headers = "MIME-Version: 1.0\r\n";

             $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

             $headers .= "FROM: {$webname} <{$adminemail}>";

             $headers .= "Reply-To: {$adminemail}\n";

             $headers .= "Return-Path: {$adminemail}\n";

             $message = str_replace( "'", "single_quote", $message );

             $message = str_replace( "\"", "double_quote", $message );

             

             $x = mail( $to, $subject, $message, $headers );

             

             

             

          echo $message."<br>";

          echo $mail."<br>";

         //$x++;

 // echo $nome."<br>";

  

  }

  ?>

	 

	Importante: antes de passar por aqui, tentei tudo que esta a meu alcance, mas não consegui.

	 

	Obrigado