database text

[mr_badger]

I have text ina database that I can view in a webpage but there is no formatting. Is there some way of creating page breaks or paragraphs from text in a database?

[chocopi]

well as long as you use textarea you can use nl2br() to insert it into the database and then when you retrieve it, it should remain the same

 

EG

$text = nl2br($text);

 

Hope it helps 

 

~ Chocopi

[wildteen88]

well as long as you use textarea you can use nl2br() to insert it into the database and then when you retrieve it, it should remain the same

 

EG

$text = nl2br($text);

 

Hope it helps 

 

~ Chocopi

Don't use nl2br when you insert text into the database. Only use nl2br when you go to display the text to the page. The database will preserve whitespace characters (newlines). The browser ignores whitespace characters that is why when you print text will newlines in it shows it as just one line. When you use nl2br it converts the whitespace newline chars into a HTML line break (<br />).

[chocopi]

Thanks for correcting my mistake, god knows why i put that