Send email

[Anon]

Hi all,

Can anyone see the error in the script below.
I keep getting: No recipient addresses found in header
Any ideas?

@ $db = mysql_connect('localhost', '', '');

if (!$db)

{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("typhoon");

$query = "SELECT post_id, reply_email, autorespond FROM reply WHERE post_id = $post_id AND autorespond = 'yes'";
$result = mysql_query($query) or die(mysql_error());
while($send = mysql_fetch_array($result)){
mail($send["$reply_email"], "New reply in post", "There was a new posting :" . $reply_topic_name );
}

$query = "insert into reply(post_id, reply_name, reply_email, reply_topic_name, reply_post, reply_time_stamp, autorespond, replies)
values('$post_id','$reply_name','$reply_email','$reply_topic_name','$reply_post','$reply_time_stamp','$autorespond','$replies')";

$result = mysql_query($query);

if($result)

echo "<font face=Verdana, Arial size=2>Your band information was successfully inserted into the database.</font><br>";

}

echo "<br><a href=\"typh_forum.php\">Back to main page</a>";
?>

[Anon]

Try changing this:

$send["$reply_email"],

to this:

$send["reply_email"],

[Anon]

Thanks Martin.
Just another thing...when i receive the email the link back to the post isn't a link.
What do i need to change in the code inorder for this to work?

$query = "SELECT distinct(reply_email) FROM reply WHERE post_id = $post_id AND autorespond = 'yes'";
$result = mysql_query($query) or die(mysql_error());
while($send = mysql_fetch_array($result)){
mail($send["reply_email"], "Reply to post", "Hello,\n\n$reply_name has just replied to the thread posted at Typhoon Entertainment\n\nThis thread is located at:\n<a href=http://www.typhoon-ent.com.au/typh_forum1.php?id=$post_id</a>");
}

[Anon]

You may need to change the header info of the email, however try first changing

<a href=http://www.typhoon-ent.com.au/typh_forum1.php?id=$post_id</a>");

to

<a href=\"http://www.typhoon-ent.com.au/typh_forum1.php?id=$post_id</a>\"");