[RESOLVED] help with database array

mrwhitee

Cant get this script to work. Please help.

<?php


$username = "my name";
$password = "my password";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("mydb",$dbh) 
	or die("Could not select mydb");
$result = mysql_query("SELECT email FROM news");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo $row{'email'}.",<br>";
}

$maillist = array($row{'email'});

echo $maillist;

foreach($maillist as $maillist) {
mail("$maillist","subject","Content");
}

mysql_close($dbh);

?>

</body

I was able to make an array like this:

<?php
$maillist = array('myemail@nowhere.com', 'amotheremail@somewhere.com', 'youremail@nowhere.com');

foreach($maillist as $maillist) {
mail("$maillist","subject","Content");

}
?>

which works fine but cant get it to work with the database. Please help.

YAOMK

what error do you get from your database?

mrwhitee

no error . It just doesnt mail.
my exact ouput the screen is:

Connected to MySQL
email address 1,
email address2,
email address3,
Array

which is as it should be as I have it to echo all that but the emails dont go. I know I am getting results from the database because it has the real emails on the screen. I think I am doing something wrong when I try to put the results in the $maillist array. Works perfectly on the second script without a database.

mrwhitee

Actually, I think the mail function is getting "Array" passed to it instead of the value of the email. So no email is sent.

YAOMK

$maillist = array($row{'email'});

is outside your while loop, if you were to do this:

print_r($maillist);

you would see it is not being passed the list of emails as you intend it to.

try:

<?php


$username = "my name";
$password = "my password";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("mydb",$dbh) 
	or die("Could not select mydb");
$result = mysql_query("SELECT email FROM news");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo $row['email'].",<br>";
$maillist[] = $row['email']);
}



echo $maillist;

foreach($maillist as $email) {
mail("$email","subject","Content");
}

mysql_close($dbh);

?>

mrwhitee

Yes that worked! Thanks a million. I prolly would have spent a few more hours before I figured it out and Im already getting sleepy and making mistakes.

YAOMK

Glad it worked, happy thanksgivings!

mrwhitee

It will be much happier now. Wont have to listen to my wife nagging at me tomorrow because I wont quit working on this. lol.
Happy thanksgiving to you too.