faqts : Computers : Databases : MySQL

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

7 of 54 people (13%) answered Yes
Recently 1 of 10 people (10%) answered Yes

Entry

Storing HTML tags in MySQL data

Feb 22nd, 2008 20:21
dman, Euan MacInnes, Mark Gowdy, http://sturly.com


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!")