Programming Forums > Web Development and Design > Other Web Development Languages

woocha · Sep 14th, 2007, 1:11 PM

here is an attached photo of the available fields

DaWei · Sep 14th, 2007, 1:13 PM

No, write your message as if it's an HTML page. Some people won't have the ability to display HTML, though, so bear that in mind. You might want to send it as a mult-part message, with one part text/plain and the other part text/html.

You should see the RFC for details. Alternatively, view the source of some message you've received in HTML. You'll see what I mean.

woocha · Sep 14th, 2007, 1:16 PM

Quote:

Originally Posted by DaWei

No, write your message as if it's an HTML page. Some people won't have the ability to display HTML, though, so bear that in mind. You might want to send it as a mult-part message, with one part text/plain and the other part text/html.

You should see the RFC for details. Alternatively, view the source of some message you've received in HTML. You'll see what I mean.

What is "RFC"?

DaWei · Sep 14th, 2007, 4:52 PM

. Your credibility as an expert provider is rising by the second.

woocha · Sep 14th, 2007, 4:53 PM

xpert provider of what.....

woocha · Sep 14th, 2007, 5:02 PM

Quote:

Originally Posted by DaWei

. Your credibility as an expert provider is rising by the second.

then Stop replying to my posts, you mean old bastard.....

woocha · Sep 14th, 2007, 7:37 PM

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.

(Toggle Plain Text)

$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

ReggaetonKing · Sep 14th, 2007, 10:58 PM

Sorry about that man. I only tried to help.

woocha · Sep 15th, 2007, 4:22 AM

Quote:

Originally Posted by ReggaetonKing

Sorry about that man. I only tried to help.

No....thank you very much for your help.....by looking at the DB in PHPMyAdmin, I was able to learn an offal lot about some things I had not plaed with before, so Thank you.

Sep 14th, 2007, 1:13 PM	#12
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	No, write your message as if it's an HTML page. Some people won't have the ability to display HTML, though, so bear that in mind. You might want to send it as a mult-part message, with one part text/plain and the other part text/html. You should see the RFC for details. Alternatively, view the source of some message you've received in HTML. You'll see what I mean. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Sep 14th, 2007, 4:52 PM	#14
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	. Your credibility as an expert provider is rising by the second. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Sep 14th, 2007, 4:53 PM	#15
woocha Newbie Join Date: Aug 2007 Location: online at woocha.com Posts: 24 Rep Power: 0	xpert provider of what..... __________________ FREE Online Auctions at: http://www.woocha.com/auctions

Sep 14th, 2007, 7:37 PM	#17
woocha Newbie Join Date: Aug 2007 Location: online at woocha.com Posts: 24 Rep Power: 0	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. (Toggle Plain Text) $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); } } $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 __________________ FREE Online Auctions at: http://www.woocha.com/auctions

Sep 14th, 2007, 10:58 PM	#18
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	Sorry about that man. I only tried to help. __________________ I would love to change the world, but they won't give me the source code!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
start Learning HTMl	smita	HTML / XHTML / CSS	0	Mar 15th, 2007 7:38 AM
Basic HTML Tutorial - Reuben Keeney	ReubenK	HTML / XHTML / CSS	14	Mar 26th, 2006 5:50 AM
How to detect cursor location and insert text???	syntax-error	C#	3	Jun 30th, 2005 1:42 AM
how do i automate text data and input into database?	lionel84	C#	0	Jun 26th, 2005 9:35 PM

Programming Forums > Web Development and Design > Other Web Development Languages

store HTML is a text field in a table on a MySQL Database