How do I display text from a database and recognise the paragraphing

[joshgarrod]

Hi all, I am hoping I am able to explain this so here goes:

 

I have a form which inserts data into a table, one field is a textarea. When typing in the textarea you can hit enter to start a new paragraph. But when I pull this info from the database and display it, it appears in one large clump. How do I get PHP to recognise the paragraph?

 

Thanks in advance.

[joe92]

Do you mean something like the nl2br function?

[joshgarrod]

Yes but that appears to need someone to type \n... how do I get it to do it itself?

[EdwinPaul]

When the user hits enter, an invisable new line-simbol is inserted. You can store the textarea in your database. When displaying it later, you use the nl2br() function. (nl2br means: "new line to break")

[$php_mysql$]

when u print ur string use it like nl2br($string); btw are u using textarea or?

[joshgarrod]

Thats awesome thanks I will try that.

 

$php_mysql$ - I am using a textarea to pull the data from

[$php_mysql$]

cool then this is how i do after i fetch the data form db i store it on a variable like this

 

$text = nl2br($text);

 

and then when i echo $text i get clear results :-)

[joshgarrod]

cheers for that, exactly what I wanted - PHP really does have an answr for everything!