new line storing problem

[barantamer]

hello , i am using a texbox to store a msg in my database
and using these 2 functions before storing the post.

$post=htmlentities($post);
$post=mysql_real_escape_string($post); 

however i am loosing new lines .

line in the text box

kamil
baran
tamer

this is the way it is displayed when i call the post back from database

kamil baran tamer

any help?

[NogDog]

I would recommend not using htmlentities for storing the text in the database, as you are then assuming that data will only ever be used for HTML. Instead use it after retrieving the data and specifically outputting it as [X]HTML. Then when you output it, you can also use the nl2br() function to add <br /> tags wherever there is a newline:

echo nl2br(htmlentities($value_from_database)); 

[barantamer]

thanks alot its workin..
i have another question.

is

$post=mysql_real_escape_string($post); 

enough to avoid injection?

[NogDog]

Yes (assuming you mean SQL injection).

[barantamer]

thanks