If I understand correctly, your data in the database is text, with newline characters in it, and you wish to display that data with the newlines in it, as one would expect a text editor to do.

If this is the case, you have two options.

Option 1

Use a <pre /> block, like so:

print "<pre>$text</p>";
[download]

Note that it is advised to escape the text so that there is no possibility of XSS or conflicts with HTML special characters.
CGI can do that:

print "<pre>", CGI::escapeHTML($text), "</pre>";
[download]

Option 2

To use the HTML paragraph block, simply use a regular expression to replace all newline characters with the HTML <br />.
Regular expressions are a very important part of the Perl language, and therefore left as an exercise to the reader. ;-)

~Thomas~ 

"Excuse me for butting in, but I'm interrupt-driven..."

I have tried option one and it did not work. I am not so good at regular expression although i am learning gradually about it.

Please are there resources online where i can get help or read about what i need to do in other to display paragraphs as i did while inserting text into a database using Perl.

Depends on what you mean by "get help" -- if you mean 'do it for you,' hire a programer. If you mean help fix your code, you'll have to show it to us, and not just say "it did not work."

But if you mean 'get help learning how to....' -- well, http://www.perlmonks.com/index.pl?node=Tutorials#Pattern-Matching-Regular-Expressions-and-Parsing is just awaiting your visit.

And in that same vein, I'm not clear what you $text looks like, coming out of the database, so can't even guess why the snippet you show does "not work."

However, another and better option might be to stick the text into the db with html markup...

<p>para 1</p>
<p>Slightly more extensive para two:</p>
  <ol><li>with details</li>
      <li>with details</li>
  </ol>
<p>Pare 3 loret ipsum etc....</p>
[download]

That:

para 1

Slightly more extensive para two:

1. with details
2. with details

Pare 3 loret ipsum etc....

combined with whatever escaping demanded by your code, should do the job.

BTW, re the first reply, above, <br /> is NOT para code as the node might seem to suggest. It's an entity which produces a single linebreak (like 0d, 0a in a windows file) but not a para break which puts in an extra linebreak so paras are separated by a line blank except for the newline.




check Ln42!

My problem here is when i retrieve the data from the database and display it using Perl there are no newlines displayed on the page the text is all joined together.

Newlines -- as represented by \n -- are considered whitespace like any other in HTML and rendered as such, rather than as actual newlines (outside of tags such as <pre> and <code>, anyway). You need to turn them into <br> tags:

$text =~ s#\n#<br>#g;
[download]

These'll indicate that the browser should render linebreaks.