View Single Post
  #1  
Old 08-11-2006, 03:09 PM
daffy daffy is offline
OSP Starters
 
Join Date: Aug 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
daffy is on a distinguished road
Red face not able to display the /r/n from mysql

I have tried many times to display the /r/n from mysql, but I still failed!

I enter the message in the textarea
"this is text message
this is text message 2
this is text message 3"

and insert to mysql
and i see the result in mysql by using(phpmyadmin) is
this is text message\r\n this is text message 2\r\n this is text message 3\r\n

but when i run the query to sql i return the value is
"this is text message this is text message 2 this is text message 3"
The \r\n is missing!

can ireturn the value in this format?
"this is text message <BR>
this is text message 2 <BR>
this is text message 3"

or retrieve the \r\n from mysql?

Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - not able to display the /r/n from mysql
View Single Post
  #1  
Old 08-11-2006, 03:09 PM
daffy daffy is offline
OSP Starters
 
Join Date: Aug 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
daffy is on a distinguished road
Red face not able to display the /r/n from mysql

I have tried many times to display the /r/n from mysql, but I still failed!

I enter the message in the textarea
"this is text message
this is text message 2
this is text message 3"

and insert to mysql
and i see the result in mysql by using(phpmyadmin) is
this is text message\r\n this is text message 2\r\n this is text message 3\r\n

but when i run the query to sql i return the value is
"this is text message this is text message 2 this is text message 3"
The \r\n is missing!

can ireturn the value in this format?
"this is text message <BR>
this is text message 2 <BR>
this is text message 3"

or retrieve the \r\n from mysql?

Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote