mysql_fetch_array problem

[Chris_96_WS6]

I'm trying to generate a mass email with the BCC list coming out of a database table. The message body comes from a form POST...

here's what I have so far:

// query subscriber emails
$query = "SELECT Email FROM table";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

//send email to subscribers
$EmailMsg = "Weekly Email\n\n";
$EmailMsg .= "$Message\n\n";

$to = "[e-mail]";

$subject = "Weekly Tip";
$mailheaders = "From:[e-mail]\n";
$mailheaders .= "Reply-to: [e-mail]\n";

while ($row = msql_fetch_object($result)) {
echo $row->Email;
$Email = $row['Email'];
echo $mailheaders .= "Bcc: $Email\n";
}

mail($to, $subject, $EmailMsg, $mailheaders);

I get this error: Fatal error: Call to undefined function: msql_fetch_array()

Can anybody tell me what I'm doing wrong?

[cgraz]

it just means the function msql_fetch_array() does not exist. It's a typo. should be mysql_fetch_array() (notice the y after the m)

The error messages give you a good hint as to what's causing the problem. Those typos can be hard to catch though.

[Houdini]

right here

while ($row = msql_fetch_object($result)) {//this should be
while ($row = mysql_fetch_object($result)) {

[Chris_96_WS6]

DUH.

Can't believe I started at it all day and didn't see that. Thanks guys. It works flawlessley now 😃

Bookmarking this site for my regular rotation along with car and politics boards 🆒