Echoing MySQL query with page breaks

[underline]

I'm trying to figure out when I echo a row (using mysql_fetch_array, then using $row['column name']) it outputs as a single line, ignoring the page breaks that exist in the database. When I make a <textarea> and set the echo as the value, it includes the breaks. Is there another way to output the spaces or will I have to edit the database values?

 

Thanks in advance 

 

Here is a part from the form:

<?php
$result = mysql_query("SELECT * FROM system WHERE UserID='$id'");
$row = mysql_fetch_array($result);
?>
  <tr>
    <td>Name</td>
    <td><?php echo $row['Name']; ?></td>
  </tr>

[mrMarcus]

and...what do these page breaks look like?  <br />?  \n?

 

EDIT: you might want/need to look into nl2br()

[underline]

I use phpMyAdmin- I can't necessarily tell what they are. When I view the page source it shows as <br> (but I assume it could still be different)

[underline]

and...what do these page breaks look like?  <br />?  \n?

 

EDIT: you might want/need to look into nl2br()

 

That worked! Thanks a lot.

[mikesta707]

they are newline characters. In plain text (which text areas are) line breaks are caused by new lines. In html they are caused by the line break tage (<br />) Marcus is correct, you should look into the nl2br() function

 

edit: oh nvm then too late