[Resolved] database/mail question

[gunhoe86]

in my MySQL database, each row has an email address and I'd like to send an message to each of those emails. right now i just have:

mail("[e-mail]","$subject","$message","$from");
mail("[e-mail]","$subject","$message","$from");
mail("[e-mail]","$subject","$message","$from");

etc. The problem is theres nearly 100 mail() functions for each email address. here's what i have thus far.

$query = "select email from emails";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
mail("$row","$subject","$message","$from");
}

is there a way to put each email into a mail() function that sends an email to each address?

~JOSH

[yelvington]

Read the mysql section of the PHP manual again.

$row is an associative array. To obtain a member of that array, use the field name.

$row['email']

[gunhoe86]

if i have to say

$row['[e-mail]']
$row['[e-mail]']

then thats just the same as

mail([e-mail])
mail([e-mail])

ive done some more work and here is what i have so far:

$query = "select email from sendemail";

$result = mysql_query($query)
or die ("queryError");

$email = mysql_fetch_assoc($result);

$eachemail = each($email);

for ($i=0;$i<sizeof($eachemail);$i++)
{
mail("$eachemail","$subject","$message","$from");
echo ("$eachemail");
}

it sends out four emails, each one to [e-mail] and naturally they all get returned bc there is no [e-mail]

how can i get each email address from $email to the mail() function in the loop?

~JOSH

[saracen]

What he means Gunhoe is that $row is the answer to your problem in the first post and the second. It is an associative array, ie it goes and gets every field listed under a specified column. Hence:

$email=$row['email']

would get you all the emails in your email column. Therefore if you run it under a WHILE and FETCH ARRAY statement it will get you all the emails.

[gunhoe86]

ok i see

i had tried that before but kept getting a parse error when i did this:

$row['email']

but when i did this:

$row[email]

it worked fine

thanks for the help and sorry for my lack of knowledge

~JOSH

[saracen]

Whether the quotes are placed or not depends on ur code.

Dont apologise for asking dude. No-one on here was born knowing php and if it makes you feel any better I consider myself a newbie!🙂