brady.k — Fri, 13 Feb 2004 01:33:26 +0000

I didn't know there was an "industry standard"...geez! lol. It all works though, thanks.

Suzanne — Thu, 12 Feb 2004 04:31:15 +0000

You're right, Saeed, and this is the third or fourth thread where that wily Kyle has tripped people up by insisting on using _row instead of _array! D'oh!

brady.k — Thu, 12 Feb 2004 04:17:48 +0000

it works fantastically wonderful! (british accent)

lol...thanks.

zollet — Thu, 12 Feb 2004 01:28:40 +0000

Actually, what all of you missed is that Eskater05 is using mysql_fetch_row() to get the data from MySQL. This function stores the data in a numeric array ($emails[0], $emails[1], etc). Therefore, the variable $emails['email'] is empty, hence no emails being sent.

mysql_fetch_row() = $array[0], $array[1], etc
mysql_fetch_assoc() = $array['name'], $array['email'], etc
mysql_fetch_array() = Combination of both above functions

brady.k — Thu, 12 Feb 2004 00:14:29 +0000

I'm still getting an error, so I'll talk to my host...I checked documentation and such, nothing on it at all. Thanks for the help.

Mark Hensler — Wed, 11 Feb 2004 06:44:49 +0000

No. that will send the first email to the first address. The second email to the first and second addresses. The third.. etc.

<?php
// ...connection...
$query = mysql_query(\"SELECT email FROM elist\");
while ($emails = mysql_fetch_row($query)) {
    echo \"Emailing '\".$emails['email'].\"'\";
    if (mail($emails['email'],$_POST['subject'],$_POST['body'])) {
        echo \" - OK\n<br />\";
    }
    else {
        echo \" - ERROR\n<br />\";
        // break;
    }
};

// ...closing...
?>

nike_guy_man — Wed, 11 Feb 2004 04:43:26 +0000

<?php
...connection... 
$query = mysql_query(\"SELECT email FROM elist\"); 
while ($emails = mysql_fetch_row($query)) { 
    $sendto = \"$sendto, $emails['email']\"; 
    mail($sendto,$_POST['subject'],$_POST['body']); 
}; 

...closing... 
?>

I think....

m3rajk — Wed, 11 Feb 2004 02:19:57 +0000

check on the apache configs. the other thing can be mx tables. places like hotmail and yahoo wont accept if mx tables aren't correct