how to echo a populated php array

Question

I have this code:

<?php 
$result_array1 = array();
$sql1 = "SELECT * FROM  `test_thing`";
$result1 = mysql_query("$sql1") or die($sql1.mysql_error());
while($row1 = mysql_fetch_array($result1))
    {
       $result_array1[] = $row1['email'];
    }
$sentmail = mail($result_array1,$subject,$message,$header);
?>

My problem is that if I place the mail function inside the loop, the user receives many emails instead of one, and if I place it out of the loop, no email is sent. My aim is to send only 1 email to each user, but that email should containt in it many mixed emails. I have read in other forums that it can be done using arrays. Maybe there is a mistake with the codes. Any suggestions?

Thanks

Shouldn't it be mysql_fetch_assoc instead of mysql_fetch_array? — Dmytro Shevchenko
– Dmytro Shevchenko, Commented May 5, 2012 at 18:46
@Shedal It could be, but by default mysql_fetch_array() gets both associative and numeric keys so this works fine. — Michael Berkowski
– Michael Berkowski, Commented May 5, 2012 at 18:46

Nauphal · Accepted Answer · 2012-05-05 19:26:03Z

1

try this

<?php 
$result_array1 = array();
$sql1 = "SELECT * FROM  `test_thing`";
$result1 = mysql_query("$sql1") or die($sql1.mysql_error());
while($row1 = mysql_fetch_array($result1))
    {
       $result_array1[] = $row1['email'];
    }
$email = implode(",",$result_array1); // $email = "[email protected],[email protected],[email protected]"
$sentmail = mail($email,$subject,$message,$header);
?>

The first parameter of the mail can be a single email id or email ids separated by commas. Which means you can send the email to multiple users just using one function call.

edited May 5, 2012 at 19:26

answered May 5, 2012 at 18:46

Nauphal

6,1824 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Moyed Ansari Over a year ago

in question it is writter "My aim is to send only 1 email to each user"

Nauphal Over a year ago

@MoyedAnsari: It will send only one email to each user

Moyed Ansari Over a year ago

what if the query returns the two exactly same email addresses ?

Nauphal Over a year ago

@MoyedAnsari: what are you trying to prove ? try to understand the need of the questioner. Dont make silly aruguments

Moyed Ansari Over a year ago

what im saying that $result_array1 may has two identical emails, since there is no distinct or group by in query.

|

user267885 · Accepted Answer · 2012-05-05 18:46:01Z

0

Just use the following MySQL query:

SELECT DISTINCT email FROM  `test_thing`

It will return only unique e-mail addresses from the table. That way you can use the mail() in the loop and not worry about duplicated e-mail addresses.

answered May 5, 2012 at 18:46

user267885

Comments

CastroXXL · Accepted Answer · 2012-05-05 18:47:46Z

0

According to php.net: http://php.net/manual/en/function.mail.php

mail accepts a string for the to address. You could always implode(',', $result_array1)

answered May 5, 2012 at 18:47

CastroXXL

1615 bronze badges

Comments

MajidTaheri · Accepted Answer · 2012-05-05 18:54:48Z

0

IMHO $to parameter in mail function just one email support .if you want send to many email, change your $headers and set Bcc; sample code:

$headers.="Bcc: "; 
while($count < $count_recip){ 
$headers.=$recip[$count].", "; 
$count ++; 
}

answered May 5, 2012 at 18:54

MajidTaheri

4,0237 gold badges34 silver badges46 bronze badges

Comments

Jesse J. · Accepted Answer · 2012-11-01 19:07:06Z

0

This worked for me:

$result_array1 = array();
$sql1 = "SELECT DISTINCT * FROM  `test_thing` GROUP BY `user_id`";
$result1 = mysql_query("$sql1") or die($sql1.mysql_error());

while($row1 = mysql_fetch_array($result1))
{
    $result_array1[] = $row1['EmailAddress'];
}

$email = implode(",",$result_array1);

I modified some of the answers together.

There will be no duplicate emails either, atleast there wasn't for me.

answered Nov 1, 2012 at 19:07

Jesse J.

137 bronze badges

1 Comment

andrewsi Over a year ago

If you're only using EmailAddress from the result set, then you can just SELECT DISTINCT EmailAddress FROM ...., which will guarantee that you don't get duplicate entries for EmailAddress.

Collectives™ on Stack Overflow

how to echo a populated php array

5 Answers 5

7 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

7 Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related