[RESOLVED] Simple question

[ade1982]

When I have a textarea, and I insert it into the MySQL database, how do I preserve line breaks when entering or displaying it?

Thanks

edit:

some code

form.php

<FORM NAME="fa" ACTION="insertrec.php" METHOD="POST">
<TEXTAREA NAME="MESSAGE" ROWS=15 COLS=40></TEXTAREA>

etc.

insertrec.php

$ade = $_POST[lyrics];
$ade = str_replace("<br />", "\n", $ade);

$SQL = " INSERT INTO song ( lyrics) values";
$SQL = $SQL . "$ade";
$result = mysql_db_query($dbname,"$SQL",$conn);

etc.

[thorpe]

The linebreaks are preserved. If you want to add <br /> tags in there place when displaying the data from the database use [man]nl2br[/man].

[cahva]

Dont replace the "\n" to "<br />" when you insert them to database. Instead use nl2br() function when fetching results.

Ofcourse you can do SOME parsing and formatting to the text when inserting to database. Atleast:

$ade = mysql_real_escape_string($_POST['lyrics']);

..to make it safer to put to database.
Also its maybe better to strip html tags also:

$ade = strip_tags($_POST['lyrics']);
$ade = mysql_real_escape_string($ade);

Now when you insert those lyrics to database, there are no tags but newlines will remain and you can use nl2br() when showing them.

[ade1982]

Beautiful people, the Aussies and the Finns 😃

and it proves, Aussies are better programmers than cricketers 😃

Thanks guys