Forums

This topic is locked

Paragraph Breaks in Long Blob

Posted 23 years ago
1
has voted
23 years ago matt harris posted:
<font face='Verdana'></font id='Verdana'>
Is there any way to maintain paragraph breaks in a longblob text field in mysql? I have a large amount of news information I need to store in a mySQL database and then access this by php / ultradev but it needs to be broken up by paragraphs - can I only do this as I have done in the past with &lt;br&gt; break tags. ?

Replies

Replied 23 years ago
23 years ago Julio Taylor replied:
when you display the text in your PHP page, make sure that you add "nl2br" to the string like so:

&lt;?php echo nl2br( $field-&gt;Fields("table.field") ?&gt;

hope it helps

-- Julio

P.S. i killed kenny

Reply to this topic