Formatting text in MySQL

[Anon]

Hi!
How can I format textarea inputt in a MySQL db?
For example <br> - breaks ...?
It's easy to put the text into the db, but not formatted. How can I handle this problem?

Thanks!
Kristian

[Anon]

Hi!

Line Breaks can be generated by:

$myNewString = nl2br($myString);

...but I think you should not do this. When you insert text (with line breaks) from a textarea the line feed character will also be stored in the database.
You should better format this text AFTER output from database:

$result = mysql_query("select * from mytable");
while ($myRows=mysql_fetch_array($result)) {

echo nl2br($myRows[myColumn]) . "<BR>";

}

[Anon]

Thanks!
This worked out perfectly!

[mfacer]

Thanks for posting this code Herwig, I have been looking everywhere for some code to allow line breaks in my HTML output!

Brilliant!

M@ Facer.