empty lines between paragraphs HELP!!

[jonsof]

i have a large text area where i write message like this

xxxxxxxxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
.......

The problem is that when i save it into the database the empty lines between the first row and the following paragraph go and then i output the message above without vacant rows.

What can i do for that?

Thanks in advance!

[jonsof]

any ideas?

[SP8600]

I have the same problem but have no idea at all how to sort it. So any help for us would be great guys

[jonsof]

i found the solution for that

ereg_replace("\n","<br>",$string);

it works!

[Ulujain]

Or

$string = nl2br($string);

[planetsim]

I suggest using jonsof. Its a very popular way of doing it. These forums use it if im not mistaken

[SP8600]

Were does

ereg_replace("\n","<br>",$string);

go though

[cgraz]

That would go right before you print the info to the user. For example, below is a sample script where you select the data from the database, use ereg_replace, then display it to user

$query = mysql_query("SELECT text_area FROM your_table WHERE id='$id'");

while($a_row=mysql_fetch_array($query)) {

$text_area = $a_row["text_area"];
$text_area2 = ereg_replace("\n","<br>",$text_area);

}

echo $text_area2;

The above code sleects text_area (the field) from your table, creates a var $text_area that contains the value held in the db, then creates $text_area2 which replaces \n (newlines) with breaks.

I personally use str_replace("\n", "<br>", $string) (which does the same thing), but a lot of people will argue that nl2br() is basically a function that does the same thing.

$query = mysql_query("SELECT text_area FROM your_table WHERE id='$id'");

while($a_row=mysql_fetch_array($query)) {

$text_area = nl2br($a_row["text_area"]);
echo $text_area;

}

Cgraz