Mailing List

[klik]

Hi,

I have the following code which is meant to send an email to everyone who has subscribed to the mailing list. It works, however every member receives the e-mail twice.

Code below.

	$sql = mysql_query("SELECT email FROM cms_users WHERE mailing_list='1'");
	$participants = mysql_num_rows($sql);
	$fetch = mysql_fetch_array($sql);

foreach($fetch as $to){
	mail($to, "$subject", "$body", "FROM: webmaster <[e-mail]>");
} 

[vaaaska]

I bet the problem is in your query. Use print_r($fetch) to see what you are getting from your query. I think you need to tighten it up.

[klik]

I can't see how the query can be incorrect. It searches for all the emails held in the database which have subscribed to the Mailing List.

So I'm really not sure what to amend it to.. 🙁

[Matt_Kindig]

Could you post the results of your print_r($fetch) statement? That would help a lot.

[klik]

Sure thing. Here it is.

Array ( [0] => [e-mail] [email] => [e-mail] ) Array ( [0] => [e-mail] [email] => [e-mail] )

[Matt_Kindig]

Very strange...your print_r($fetch) statement seems to imply that each email entry is entered into your DB twice.

Do this:

$sql_=_mysql_query("SELECT email FROM cms_users WHERE 1");
$fetch=mysql_fetch_array($sql);
print_r($fetch); 

and post the results. I think that whatever command you use to insert data into your db and inserting each row twice, and so you are correctly retrieving both of these rows.

[klik]

Here are the results:

Array ( [0] => [e-mail] [email] => [e-mail] )

[klik]

The results are strange, since I have 2 members held in the database with emails and who have both mailing_list set at 1.