[PHP] Formatted text from mySQL DB

[Cpt John W. Holmes]

From: "PHPSpooky" <phpspooky@mjimm.com>

> When I create any field and let data be sent into my mySQL DB through
> it.. it goes ok. But when I retrieve it.. the data comes completely
> unformatted.

Ah, this question again. Has it been four days already?

HTML does not render new lines. Have a look at the source code of your page
and you'll see that the text is indeed on separate lines. HTML only
understands something like <br />, though, to go to a new line. So, you need
to replace the new line characters with HTML breaks in order to maintain
appearance.

[url]www.php.net/nl2br[/url]

---John Holmes...

[Phpspooky]

> [snip]
> Ah, this question again. Has it been four days already?
> [/snip]
>
> ROFLMFAO!!!!! I snorted coffee through my nose!!! :)

Ewwwwwwwwww!!!! I do not like coffee in my mouth.. but nostrils! Yuck!

PHPSpooky

[Phpspooky]

Astrum Et Securis!

Thanks all.. for the very needed input.

[url]www.php.net/nl2br[/url] has been very helpful. I'm still testing out the
different ways. There appears to be a differentiation between people's
usage and formulas for the same. While some find nl2br() very helpful,
others find it a waste of time. And some have their own ereg_replace()
formulas assisting them.

A little bit of testing will have me on my way.

Thanks again..

Dominor!
PHPSpooky

> HTML does not render new lines. Have a look at the source code of your
> page
> and you'll see that the text is indeed on separate lines. HTML only
> understands something like <br />, though, to go to a new line. So,

you

> need
> to replace the new line characters with HTML breaks in order to

maintain

> appearance.
>
>

[Phpspooky]

Astrum!

$wow = nl2br($myrow[data]);
echo $wow;

works excellect for me!!

Thanks!!

Dominor. .
PHPSpooky