Re: How do you create ascii line breaks

[gerald_clark]

Daniel Crompton wrote:

How do you create ascii line breaks in a text paragraph in mysql?.

When displaying text taken from a mysql row it displays it all as a flowing paragraph  ie

sdf sdfgfj fgjhgfh fgj fgj hfj hj  hg gh hgk ghk gj gh kg k hg hg jh j fgj fg

When i need to look like

sdf sdfgfj fgjhgfh
fgj fgj hfj hj  
hg gh hgk ghk 
gj gh kg k hg 
hg jh j fgj fg

I am dispalying it in a webbrowser using the below code which will convert ascii 
line breaks into HTML <br> tags. but i am unsure how to put in the ascii line breaks
into mysql.

<?php echo nl2br($row_myRecordset['myField']); ?>

The string you are storing in the text field must have the line feeds in 
it before it is quoted and saved.
How they get there depends on the language you are using to generate the 
data.  This is not a MySQL
question.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]