mysql output in textarea

[php new bie]

hello , i don't know if it is mysql or php or html issue ,

 

i have php script that do mysql Query and post the result into textarea .

 

so when i make connection to DB and Query username and email in format

$query = "SELECT * FROM USERINFO ";

 

and fetching the row into the appropriate columns name , the output in the textarea field appears with NO new line "\n".

 

$result = $row['username'] .";". $row['email'] ;

 

Then :

echo $result."\n";

 

output like this :

--- textarea ---

username1:email1username2:email2 ...etc

---  / textarea ---

 

while i need :

--- textarea ---

username1:email1

username2:email2

---  / textarea ---

 

then i try :

$result = $row['username'] .";". $row['email'] ."\n" ;

 

then echo the result

 

same problem  no break ..

any help ?

[trq]

Are you trimming the newline char before insertion?

[php new bie]

I am just showing the username:email fields into  a textarea output , the problem is formating the result through the textarea to make every row in new line .

 

without textarea i use

echo "<PRE>";

echo $result ;

echo "</PRE>";

 

or just

 

echo $result . "<br / >";

 

and that works fine .

 

but when the result appears through <textarea>  it is not in a neat format .

[trq]

I'm asking if your sure your saving the newline chars to the database on the way in? They should display without any problem on the way out as long as they haven't been removed.