How can I format-output data from Mysql to a file?-relatively long

[runsun]

I am new in PHP/Mysql. I want to input sth from website to mysql, then output the formatted data to .txt, and finally use Excel to open the .txt file. I believe there are better and simpler ways than what I did. But I want to know what's wrong in my codes. Here are the details:
In survey.html, I need people input their ID and comment.
In Mysql, I've already made the survey table.
I use survey_result.php to import people's input to that table in Mysql.
Then I use survey_file.php to get data in Mysql into a survey.txt file.
Later I use Excel to open this .txt file.

My problem is, if more than one paragraph entered in "comment" field in survey.html, like:
good,
very good!
ok!

the last two paragraphs appeared in the first column (ID) in the survey.txt file.
But what I expect is they be in the 2nd (i.e., comment) column; and when I use Excel to open the .txt file, all these three paragraphs should be in one cell in the comment column.

Below are the key codes/descriptions:

"survey.html"
<input type="text" size="30" name="ID">
<TEXTAREA NAME="Comment" ROWS=18 COLS=50></TEXTAREA>
 
"survey table in mysql"
Field           Type       Null     Key   Default   Extra
id                char(2)    YES            NULL
comment     text         YES            NULL
 
"survey_result.php"
$query = "insert into bar values
('".$id."','".$comment."')";
 
"survey_file.php"
$fp = fopen("survey.txt", 'wb');
$row = $result->fetch_assoc();      
fprintf ($fp, "%s\t%s\n",$row['id'], $row['comment']);
 
"survey.txt"
ID              Comment
15             good,
very good!
ok!
 

[ronverdonk]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR