Page 1 of 1

How to get line breaker from blob field in mysql

Posted: Mon Jun 07, 2010 2:00 am
by Muhammad Omar
My Question is "How to get line breaker from blob field in mysql using php."
in my database some fields are blob .
in these blobs i save many paragraphs in one field.
i am trying to show these fields in it's original style.
but i am failed to do that.
it shows all paragraph in one paragraph.
but i want to show separate paragraphs.
tell me how can i do this. soon

Re: how to use line breaker in blob filed in mysql

Posted: Mon Jun 07, 2010 6:53 am
by Benjamin

Code: Select all

$lineBreaker = "\n";
:arrow: Moved to PHP - Code

Re: how to use line breaker in blob filed in mysql

Posted: Wed Jun 09, 2010 6:42 am
by Muhammad Omar
Hi,
Sorry one thing i forget to mentioned data is already stored in db so i am just pulling from blob field one thing i note in SQLyoug i can see data properly showing but when i fetch it using php and echo on page it come without breaker.
Thanks for replying.

Re: How to get line breaker from blob field in mysql

Posted: Wed Jun 23, 2010 4:33 pm
by Muhammad Omar
Waiting for Reply.

Re: How to get line breaker from blob field in mysql

Posted: Wed Jun 23, 2010 9:09 pm
by Benjamin

Code: Select all

$n = nl2br($y);