problem with while loop

[jmcc]

Then I use the while look in my code no emails are sent, but when I take it out only one is sent.

Are there any other ways that I loop through the recordset to send email to everyone.

Please help

 

Here's the code:

 

elseif ( $to == "Buyers") {

mysql_select_db($database_prop, $prop);

$query_dist = ("SELECT DISTINCT email FROM private_buyer WHERE notify = '1' AND province = '$provDis' AND city = '$cityDis'");

 

$dist = mysql_query($query_dist, $prop) or die(mysql_error());

$row_dist = mysql_fetch_assoc($dist);

$totalRows_dist = mysql_num_rows($dist);

 

 

// ---------------- SEND MAIL FORM ----------------

 

 

if($totalRows_dist > 0)

{

$count = 0;

while ($rows_dist = mysql_fetch_assoc($dist))

{

echo $row_dist['email'];

// send e-mail to ...

$to2 = $row_dist['email'] . ', ';

 

echo $to2;

 

// Your subject

$subject="Property Distribution";

 

// From

$header="from: Property Networking Solutions";

 

// Your message

$messages= "Match alert notification\t\n\t\nThis property was sent to you by Property Networking Solutions.\t\n\t\nProperty Description:\t\nType: $proptype\t\nProvince: $propprov\t\nCity: $propcit\t\nSuburb: $propsub\t\nPrice: R $propprice\t\n\t\nHere is a link to the property: http://www.propertyforsalesa.co.za/buyer_detail_view.php?id=$propid\t\n\t\n\t\n" ;

 

// send email

$sentmail = mail($to2,$subject,$messages,$header);

$count++;

}

 

}

 

}

 

[KevinM1]

1. Where's your while-loop?

2. Use code tags.

[gevans]

have a look at the changes bellow and try it;

 

elseif($to == "Buyers") {
   mysql_select_db($database_prop, $prop);
   $query_dist = ("SELECT DISTINCT email FROM private_buyer WHERE notify = '1' AND province = '$provDis' AND city = '$cityDis'");

   $dist = mysql_query($query_dist, $prop) or die(mysql_error());
   $totalRows_dist = mysql_num_rows($dist);

   if($totalRows_dist > 0)
   {
      while($rows_dist = mysql_fetch_assoc($dist))
      {
         echo $row_dist['email'];
         // send e-mail to ...
         $to2 = $row_dist['email'];

         echo $to2;

         // Your subject
         $subject="Property Distribution";

         // From
         $header="from: Property Networking Solutions";

         // Your message
         $messages= "Match alert notification	 	 This property was sent to you by Property Networking Solutions.	 	 Property Description:	 Type: $proptype	 Province: $propprov	 City: $propcit	 Suburb: $propsub	 Price: R $propprice	 	 Here is a link to the property: http://www.propertyforsalesa.co.za/buyer_detail_view.php?id=$propid	 	 	 " ;

         // send email
         if(mail($to2,$subject,$messages,$header))
         {
            echo 'mail sent to '.$to2;
         }
         else
         {
            echo 'mail not sent to '.$to2;
         }
      }
   }
}

[jmcc]

I put the while in bold.

 

 

 

Here's the code:

<?php>

elseif ( $to == "Buyers") {

mysql_select_db($database_prop, $prop);

$query_dist = ("SELECT DISTINCT email FROM private_buyer WHERE notify = '1' AND province = '$provDis' AND city = '$cityDis'");

 

$dist = mysql_query($query_dist, $prop) or die(mysql_error());

$row_dist = mysql_fetch_assoc($dist);

$totalRows_dist = mysql_num_rows($dist);

 

 

// ---------------- SEND MAIL FORM ----------------

 

 

if($totalRows_dist > 0)

{

$count = 0;

while ($rows_dist = mysql_fetch_assoc($dist))

{

echo $row_dist['email'];

// send e-mail to ...

$to2 = $row_dist['email'] . ', ';

 

echo $to2;

 

// Your subject

$subject="Property Distribution";

 

// From

$header="from: Property Networking Solutions";

 

// Your message

$messages= "Match alert notification\t\n\t\nThis property was sent to you by Property Networking Solutions.\t\n\t\nProperty Description:\t\nType: $proptype\t\nProvince: $propprov\t\nCity: $propcit\t\nSuburb: $propsub\t\nPrice: R $propprice\t\n\t\nHere is a link to the property: http://page.php?id=$propid\t\n\t\n\t\n" ;

 

// send email

$sentmail = mail($to2,$subject,$messages,$header);

$count++;

}

 

}

 

}

<?>

[jmcc]

I tried the code and the and this is what I get

 

mail not sent to

 

but i received a php mail error on my server which has not smtp setup right now.

 

so it looks like it tried to send the email

 

 

[TeNDoLLA]

Well you need a smtp server on your system if you want to send mails at all.