[SOLVED] Adding breaks problem?

[A JM]

I'm trying to add breaks to my $comment line but its not working as I anticpiated, can someone help me out with this?

 

It just runs on with breaking after each item in the query...?

 

 

<?php
$query_rstcomments = "SELECT comment FROM comments;
$rstcomments = mysql_query($query_rstcomments, $dbconn) or die(mysql_error());
while ($rec=mysql_fetch_assoc($rstcomments)){
$comment = $comment . "\n" . $rec['comment'];
}
?>

 

 

<textarea cols="40" wrap="virtual" disabled="disabled"><?php echo $comment; ?></textarea>

 

 

Thanks.

 

A JM,

 

[Batosi]

<?php 
$comment = $comment . "\n" . $rec['comment'];
?>

[A JM]

Not sure why the backslash didn't show up but that is what I'm currently using? escaping I'm guessing is my problem...?

 

<?php
$query_rstcomments = "SELECT comment FROM comments;
$rstcomments = mysql_query($query_rstcomments, $dbconn) or die(mysql_error());
while ($rec=mysql_fetch_assoc($rstcomments)){
   $comment = $comment . '\n' . $rec['comment'];
}
?>

[Alex]

At first glance I see 2 things:

 

1. You're missing a double quote:

 

$query_rstcomments = "SELECT comment FROM comments;

should be:

$query_rstcomments = "SELECT comment FROM comments";

 

2. For a line break "\n" to work it must be wrapped in double quotes, otherwise it'll just be read as a string.

 

So..

$comment = $comment . '\n' . $rec['comment'];

Should be:

$comment = $comment . "\n" . $rec['comment'];