[SOLVED] Losing newlines when displaying the contents of a Mysql column

[DataRater]

MySQL 5 and PHP 5

 

When I display the contents of a text column using PHP no newlines are performed.

 

I can see them in the text field when using SLOyog to view the contents.

 

How can I get them back?

 

 

 

 

[Mchl]

If the content is to be displayed within HTML page, you have to replace all newline characters (usually \n, but also \r or \n\r ) with

<br/>

tag

[xenophobia]

Use php's nl2br to convert all the newline to <br />.

[DataRater]

Perfect. Thanks a lot.