Topic: Newline in a database

[astupiduser]

Hi,

I have the following issue:
I have a form (textarea), where my user writes a text (e-mail). There are of course some newlines in it. I have to save it in a database and then read it and send it as an e-mail (function mail). The problem is, when I do that all the newlines get somehow stripped and my e-mail has only one line and looks ugly. When I read it and put itt back in the textarea, it looks as it should but not when I mail it. Does anybody have a solution?

Regards,
astupiduser

[premiso]

Before you add it to the body of the email call nl2br() on the data to convert newline characters to their html equivalent <br />

[astupiduser]

Thanks a lot, it works! 

[thorpe]

You should actually use the nl2br() function on the way out of the database, not the way in.