How to format text retrieved from an MSQL Database

[charless]

I have an application that writes text to a MySQL data base from an HTML form. The text in the MySQL table retains the formatting in the form (line breaks etc.) However when I retrieve the text and display it in an HTML layer all the formatting is gone.

Is there any way PHP can retrieve the formatting from the database?There's no way I can write code to do the formatting because I don't know how it was originally entered.

[jx2]

i think u need this

u might try wordwrap(); too

hope tht help
jx2

[charless]

Hi,

I found a solution;

<?php echo nl2br(str_replace(" ","&nbsp",stripslashes($row["textsum"]))); ?>

the nl2br function puts line breaks in and the str_replace puts the spaces back in.

[ak1dnar]

Hi,

I found a solution;

<?php echo nl2br(str_replace(" ","&nbsp",stripslashes($row["textsum"]))); ?>

the nl2br function puts line breaks in and the str_replace puts the spaces back in.

Glad you got it working. post back any time if you have any issues!