Faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

6 of 49 people (12%) answered Yes
Recently 2 of 10 people (20%) answered Yes

Entry

Storing HTML tags in MySQL data

Sep 13th, 2002 12:26
Euan MacInnes, Mark Gowdy,


The question is a little vague as to the intented use of the tags, but 
here's a simple method:
update meesageoftheday set 
field1='<table><tr><td><b><message></td></tr></table>'
Then in your ASP, just
response.write replace(recordset1("field1"),"<message>","Hi There!")