not able to display the /r/n from mysql

[daffy]

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 --

[noah]

Originally Posted by daffy

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

yup, can do it with this code

select replace(
replace(message,concat(char(13),char(10)),char(10) )
,char(10),'<br>') as message
from daTable -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --