Preserving line breaks (Text Area insertation to MySQL)

[wispas]

I have a simple form with a text area.

i add 2 line breaks to start a new paragraph and insert it into the mysql database.

 

so i retrieve the post data:

 

$city_desc = $_POST['city_desc'] ;

 

and it will stick all of the data together when i output with php.. i want it to retain the 2 line breaks so they are like new paragraphs... any ideas?

[Zane]

look at nl2br()

[fooDigi]

odd are the line breaks are being stored, but when parsed as html they are run together. try echo'ing your content with nl2br()

[greatstar00]

if u dont want to use nl2br

u can use <pre>textarea data</pre>

[wildteen88]

odd are the line breaks are being stored, but when parsed as html they are run together. try echo'ing your content with nl2br()

This is because web browsers ignore white space characters, such as new lines. In order for a new line to appear in a web browser you need use the <br /> tag. nl2br() converts new lines into <br /> tags.