line breaks recognised by MySQL?

admin

Administrator
Staff member
Can a MySQL database recognise line breaks within a chunk of text?

My problem is that when adding text to the db through a web form, the line breaks included in the textarea are ignored when the data is added to the db, and therefore the formatting is lost when the db spits it back out onto a webpage.

HTML tags such as <br> work fine but are not very friendly to a non-HTML-savvy person...

Any thoughts?...

Phil
 
Back
Top