Newlines does not appear.....

[freddyfiasko]

Hi.

Got a HTML/php-form with a textarea.
When I post the form to the MySql-db and try to recieve the info again using php, the newlines entered in the textarea does not appear. It generates only a straight line with text.

I`ve tried WRAP in the HTML/php-code without any luck.

Does anyone know wheter the problem is in PHP, MYSQL or in the form itself?

Freddy....

[bastien]

http://www.php.net/manual/en/function.nl2br.php

[[deleted]]

about nl2br(); use it only when you print the text in HTML, do not use it when you store the text in the database, because you'll lose destinction between BR tags and newlines, making it very difficult for example to store HTML in your database.

[freddyfiasko]

Tnx for your help...

The solution was to use the php-function nl2br($text-2-b-wrapped) on the textvariable sendt from the textbox BEFORE inserting to MYSQL.....

Freddy....

[[deleted]]

IT's usually better not to do the nl2br() before inserting into the database because you cannot edit the text anymore once it has been run through nl2br(). If you do want to edit it you'll have to somehow replace the BR tags with newlines, and that's not possible for example if you have real BR tags in the content itself.

[freddyfiasko]

tnx Vincente......

[mjr]

to output this textarea in html correctly you have to replace '\n' newline symbols to '<br>'

you may do it this way:

echo nl2br($textareaFetchedFromDb);