Displaying multiple lines from field

[markhkram]

I have a basic MySql database, and am trying to display a field with multiple lines entered. Only 1 line displays.

For example, the following text entered:
Line 1
Line 2

Will display the following when retrieved:
Line 1 Line 2

However in PHP My Admin when displaying the record, it displays it as:
Line 1
Line 2

How can I make this field display the lines correctly?

Thanks

<?
//My Code
$Comment=mysql_result($result,$i,"Comment");

echo $Comment; 
?>

 

[markhkram]

Figured it out, had to use the following:

echo str_replace("\n", "<br>", $Comment);

 

[jpadie]

or use the optimised built in function nl2br()

 

[vacunita]

Or surround the output with <pre> tags as it appears to be pre-formatted text.

echo "<pre>$Comment</pre>";



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.