PHP formatting MySQL text data

[weixi]

I put a news article in a MySQL field that has paragraph breaks after each paragraph. It looks like this \r\n\r\n in the MySQL database.
However, when I pull it out of the database, the article is just one very long line that wraps around the browser.
How can I reformat the stuff that comes out of the mysql database to look like what I entered with the paragraph breaks?

[matto]

replace the \r\ns by line breaks:

$text = str_replace('\r\n', '<br>', $text);

or, shorter, try:

$text = nl2br($text);