detecting Cr and Lf

[mivec]

to all,
we hv a form and a text area that will upload a news content into the database. it will be retrieved from the front end. BUT..we have a problem and the problem:

let's say we enter this into the database:

the first line.
the second line.
the third line.

and we retrieve it this way:

$result = mysql_query($query, $dbc);

if($result){
   $title = mysql_result($result, 0, 'contents');
     echo("$title");
} 

what we see in the browser is this:

the first line.the second line.the third line.

but what we want is this:

the first line.
the second line.
the third line.

all the experts out there...any how to do this?

[Nightfire]

Use the nl2br() function

$result = mysql_query($query, $dbc);

if($result){
   $title = mysql_result($result, 0, 'contents');
   echo nl2br($title);
}