how can I store breaks?

[raffael3d]

people can enter data using a textarea and it is stored in a mysql database. in that text area people hit sometimes enter. the problem is that those "breaks" are not stored. if I show the content online it is all on the same line.
how can I make that breaks are stored in the database?

[bastien]

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

[[deleted]]

"the problem is that those "breaks" are not stored. "

The breaks are stored, but they are stored as normal ASCII linebreaks, and HTML does not render those. HTML only renders BR tags as linebreaks.

Use the nl2br() function to convert the newlines to BR tags when you print the data on the page

Do not use nl2br() on the data before you put it into the database, because that makes it very difficult to edit the text again in a textarea. nl2br() generally replaces the newline by a BR tag followed again by a newline, so repeatedly calling nl2br() on the same string would add more and more BR tags...

[raffael3d]

thanks a lot. ok I tried it an applied it before publshing the data, but nothing changes.....

	while ( $row = mysql_fetch_array($result) ) {


 $contact = nl2br($row["contact"]);

print $row["contact"];
}

a

[[deleted]]

"
$contact = nl2br($row["contact"]);
print $row["contact"];
"

yes... well... hmm...

you may want to look at that again 🙂