Retrieving TEXT from MySQL

[Anon]

I have a field in my database that is of TEXT property, which will hold the comments entered by the visitor in my guest book. I have the following codes to retrieve other information from the database, for example the e-mail address and so forth. But when it comes to comments, it only returns the first line. What should I do?

$result = mysql_query("SELECT * FROM guestbook WHERE ID='$ID'", $db);
while($row = mysql_fetch_array($result))
{
//other codes here
$comment = $row['comment'];
}

Example of comment:
"Comment line 1.
Comment line 2.
Comment line 3."

When echoing $comment, it will display only "Comment line 1.".

Any solution?

[Anon]

Try this:

$sql = "SELECT * FROM guestbook WHERE ID='$ID'";

$result = mysql_db_query($db, $sql);
$num_of_rows = @mysql_num_rows($result);

for ($iindex = 0; $iindex < $num_of_rows; $iindex++) {
$record = @mysql_fetch_object($result);
echo "$record->comment";
}

[Anon]

Thanks for your code, Daarius. Actually, my first code did work! I made a mistake as I forgot to include the variable $comment inside the '<TEXTAREA></TEXTAREA>' in order to output it! It was my careless mistake.

Anyway, thanks a lot for the help.