using mail() to send to multiple people

[liquefi]

Hi everyone.

I'm trying to send a message to everyone that I have in a database. The database has only one column. I'm just not sure how to get all of the names into the mail prototype mail($to, $subject, $message, $from). I tried to treat it like an array where it counts through the names, but that doesn't seem to work.

I have tried the code below, and it seems to process, showing no errors and telling me my mail was sent. However, not mail gets to my inbox when i'm testing this.

Does anyone see what I'm doing wrong?

<?php

// create short variable(s) 
$txtSubject=$HTTP_POST_VARS['txtSubject'];
$txtMessage=$HTTP_POST_VARS['txtMessage'];

// database connection and error(s)
$dbh=mysql_connect ("localhost", "...", "...");

if (!$dbh) 
 {
  echo "Not able to connect.";
  exit;
 }

// message
$message = "$txtMessage\n".$text;

// connect to database
mysql_select_db('...'); 
$query = "select * from [i]table[/i]";
$result = mysql_query($query);

$count = 0;

while($subscriber = mysql_fetch_row($result))
{
echo mysql_error();
mail($subscriber[1], $txtSubject, $message);
}
$count++;
mysql_error();
echo "your mail has been sent";

?>

Any help would be great!

Thanks,

Brian

[Sharif]

I'm not really sure how you should go on about doing this. But I suggest you try some sort of for() loop.

[ucbones]

Hey,

It appears to me that the line you've got as

mail($subscriber[1], $txtSubject, $message);

should be

mail($subscriber[0], $txtSubject, $message); 

Remember the first field in an array has the key "[0]"

Cheers,
God Bless,

Dominic

[liquefi]

Thanks Dominic,

That was definitely a major part of my problem. I've since figured it out and it works great.

Thanks for your reply.

Brian

[ucbones]

Good stuff liquefi, don't forget to click "Mark thread resolved" if it's all sorted!

[liquefi]

I had no idea you could do that, but where can I mark it at? I'm looking at the reply page and don't see it???

Thanks,

Brian