As it turns out, the problem was in the PHP code, NOT the MySQL table.....I was missing a few step in the PHP and needed to rewrite the headers to my Mail() function...Everything is working great now, and thank you all for the help along the way.
$company_name = $r['company_name'];
$company_email = $r['email'];
if ($action == "decline")
{
$query = "delete from orders where id=$id and merchant=$merchant";
mysql_query( $query);
$message = stripslashes($r['emaildecline']);
$headers = "MIME-Version: 1.0 \r\n" .
"Content-type: text/html; charset=iso-8859-1\r\n" .
"From: $company_name <$company_email>\r\n" .
"Reply-To: $company_email";
if ($sendemail == "yes")
{
mail("\"$name\" <$email>",
"Your order has been declined!",
$message,
$headers);
}
}
I am only posting this so other people can fix this problem without having to go through what I went throuygh....If you have any questions, reply to this thread