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

woocha · Sep 14th, 2007, 11:22 AM

I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive?

I have already tried to insert < html > into the text field, but that doesn't work....The received email, just diplays the text < html > and then the rest of the text.

ANy suggestions?

titaniumdecoy · Sep 14th, 2007, 12:04 PM

You need to set the Content-Type header to text/html.

woocha · Sep 14th, 2007, 12:10 PM

Quote:

Originally Posted by titaniumdecoy

You need to set the Content-Type header to text/html.

What do you mean?
Do you mean in my php code?

here is my code:

(Toggle Plain Text)

if ($action == "decline")
{
	$query	= "delete from orders where id=$id and merchant=$merchant";
	mysql_query( $query);

if ($sendemail == "yes") 
{

  mail("\"$name\" <$email>", 
     "Your order has been declined!", 
     stripslashes($r['emaildecline']),
      "From: \"".$r['company_name']."\" <".$r['email'].">\nReply-To: ".$r['email']); 
}
}

ReggaetonKing · Sep 14th, 2007, 12:59 PM

Quote:

Originally Posted by titaniumdecoy

You need to set the Content-Type header to text/html.

Read Above!

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

Quote:

Originally Posted by ReggaetonKing

Read Above!

there is no option for text/html...there is text, date, smallint, mediumint, int bigint, float, double, dceimal, datetime, timestamp, time, year, char, tinyblob, tinytext, blob, mediumblob, mediumtext, longblob, longtext, enum, set, bool

ReggaetonKing · Sep 14th, 2007, 12:47 PM

No. In your MySQL database, you should be able to change that field's Content-Type. Are you using any GUI to manage your data?

woocha · Sep 14th, 2007, 12:50 PM

Quote:

Originally Posted by ReggaetonKing

No. In your MySQL database, you should be able to change that field's Content-Type. Are you using any GUI to manage your data?

Do you mean PHPMyAdmin?

ReggaetonKing · Sep 14th, 2007, 12:51 PM

Yes! I don't have PHPMyAdmin in front of me but when you edit your columns, you should see where you can change the Content-Type.

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

Quote:

Originally Posted by ReggaetonKing

Yes! I don't have PHPMyAdmin in front of me but when you edit your columns, you should see where you can change the Content-Type.

Yes...do you know what type it should be instead of text?

ReggaetonKing · Sep 14th, 2007, 1:07 PM

I think you're look at the wrong option list. There should be another one, maybe it's file type?

Sep 14th, 2007, 11:22 AM	#1
woocha Newbie Join Date: Aug 2007 Location: online at woocha.com Posts: 24 Rep Power: 0	store HTML is a text field in a table on a MySQL Database I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > into the text field, but that doesn't work....The received email, just diplays the text < html > and then the rest of the text. ANy suggestions? __________________ FREE Online Auctions at: http://www.woocha.com/auctions

Sep 14th, 2007, 12:47 PM	#6
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	No. In your MySQL database, you should be able to change that field's Content-Type. Are you using any GUI to manage your data? __________________ I would love to change the world, but they won't give me the source code!

Sep 14th, 2007, 12:51 PM	#8
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	Yes! I don't have PHPMyAdmin in front of me but when you edit your columns, you should see where you can change the Content-Type. __________________ I would love to change the world, but they won't give me the source code!

Sep 14th, 2007, 1:07 PM	#10
ReggaetonKing Sexy Programmer Join Date: Nov 2005 Location: New Jersey Posts: 891 Rep Power: 3	I think you're look at the wrong option list. There should be another one, maybe it's file type? __________________ I would love to change the world, but they won't give me the source code!

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

Sep 14th, 2007, 12:04 PM	#2
titaniumdecoy Expert Programmer Join Date: Nov 2005 Posts: 837 Rep Power: 3	You need to set the Content-Type header to text/html.

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

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