long text help

[imarockstar]

im trying to figure out how to format text in a database ... If I have a TEXT AREA in a form .. and an user inputs say like 5 paragraphs ... how can I have it to where mysql will display that as 5 paragraphs and not just i chunk of text when i display it at a later date ?

 

b

[liam1412]

You can do this using the nl2br() function

 

basically

 

$text = nl2br($text);

 

 

That will format it for you

[per1os]

www.php.net/nl2br

 

That would be what you are looking for.

[liam1412]

You do this when collecting from the db and not when inputting to save space.

[akitchin]

MySQL will store the text with linebreaks as either \r\n or \n.  in order to properly format it for display in HTML, you'll need to convert those "\n" characters to "<br />" tags, as HTML ignores whitespace.  PHP has a function to do just that:

 

nl2br()

 

give it a whirl.

 

EDIT:  beaten to the punch, but i'm putting this here anyway.

[imarockstar]

awsome guys I will give this a try !!! thanks ...

 

b