Fetched text looses layout...how can I keep it?

[janson_m]

Hi!

Here's the problem. I have a comments textfield in my insert form. There ppl
can type any kind of text, say for example:

Hello!
Cool site here!
Cheers!

After submitting, everything is fine. I check the db (mySQL), and the text
looks fine there, including the layout. However, when I retrieve the text on my
'view comments' page, the format is gone! Is shows the text like this:

Hello! Cool site! Cheers!

Where are my hard returns? I saw that the recordset already looses the
layout... Any suggestions as to how I can show these comments in there original
layout? I con't put the site online like this...

Thanks!!!
Magiel

[-Rb]

"janson_m" <webforumsuser@macromedia.com> wrote in message
news:dfk1dl$cej$1@forums.macromedia.com...

> Hi!
>
> Here's the problem. I have a comments textfield in my insert form. There ppl
> can type any kind of text, say for example:
>
> Hello!
> Cool site here!
> Cheers!
>
> After submitting, everything is fine. I check the db (mySQL), and the text
> looks fine there, including the layout. However, when I retrieve the text on
> my
> 'view comments' page, the format is gone! Is shows the text like this:
>
> Hello! Cool site! Cheers!
>
> Where are my hard returns? I saw that the recordset already looses the
> layout... Any suggestions as to how I can show these comments in there
> original
> layout? I con't put the site online like this...
>
> Thanks!!!
> Magiel
>

*If* you are using PHP, take a look at nl2br().

The php documentation is available at:

[url]http://www.php.net/docs.php[/url]

HTH

-Rb

[bigj9901]

This link will tell you how to do it in almost any language.

[url]http://www.jeremysmeltzer.net[/url]

[janson_m]

I *AM* using PHP, sorry for not mentioning that, and I checked out the nl2br() function. It worked beautifully! Thanks you very much! Problem solved.

Magiel