Showing News Article Paragraphs

[Fabchina]

Probably belongs in the Database forum, but I'm newbie and it pertains to PHP.

I'm building a MySQL database with news articles. It contains various rows such as Category, Date, Title, Summary, Main Text.

Here's the beef:

How do I get to keep the paragraphs that I inserted (by using Enter) when I added the news item to the database?

It just parses the text in one, long paragraph, which makes it very unpleasant to read.

I heard about the wordwrap function, but I do not want to be typing /n in the database. A plain, old 'Enter' should do the job (well, actually two since I want more than just a single line break).

Is there some way to "translate" the paragraphs I make in MySQL to the eventual web page result? I guess that question sums up my query.

Thanks.

[cgraz]

When you hit enter and the mysql stores it, it puts /n where you hit enter. So if you want your article to display the way it was typed, right before you echo it, use str_replace()

$content = str_replace("\n", "<br>\n", $content); 

echo $content;

?>

Cgraz

[Fabchina]

Ah, brilliant. Thanks a lot. I knew there had to be a simple answer!

[maestrosdelweb]

Another way is the nl2br($string) function.

Best regards.