text format

[mga_ka_php]

how do i input textarea value to mysql database that will preserve the format?

ex.

if i input a text in textarea

----------------------------------

line one

line two

----------------------------------

and transfer it to mysql database and retreive it

the text will look like this

----------------------------------------------------

line one            line two

----------------------------------------------------

it will not put it to the next line.

 

thank you.

[AndyB]

Put it in the database exactly the way you're doing. When you retrieve it, use the nl2br() function to turn new lines into html br tags:

 

echo nl2br($databasetext);