MySQL text formatting
Posted: Thu Aug 20, 2009 10:46 am
I am trying to store text with HTML formatting in a MySQL Database.
When I call the text from a swf on my webpage, it has been stripped of it's formatting. This is the flow of the data:
swf > php > mysql > php > swf
I inserted the text using phpMyAdmin fom the site's control panel. Like so:
UPDATE cms_content SET company_body='<p><b>This is a bold heading</b><br/>This is the body text.<a href = "www.website.com">This is a link</a><br/>This is some more body text.</p>'
In the swf, the text displays as one continous paragraph with no bold, italic or color formatting. (the text fields are set to display html text and I have tested this with txt files) Where is the formatting getting lost? Or am I putting the data into the database wrong?
Thanks.
When I call the text from a swf on my webpage, it has been stripped of it's formatting. This is the flow of the data:
swf > php > mysql > php > swf
I inserted the text using phpMyAdmin fom the site's control panel. Like so:
UPDATE cms_content SET company_body='<p><b>This is a bold heading</b><br/>This is the body text.<a href = "www.website.com">This is a link</a><br/>This is some more body text.</p>'
In the swf, the text displays as one continous paragraph with no bold, italic or color formatting. (the text fields are set to display html text and I have tested this with txt files) Where is the formatting getting lost? Or am I putting the data into the database wrong?
Thanks.