[RESOLVED] mysql_real_escape_string

[Shroder]

I'm having a problem where mysql_escape_string and mysql_real_escape_string is changing \r\n to rn.

I then insert it into my mysql database and its fine when I take the data out of the database, unfortunetly in some case I'll need to use the variable that is still showing the rn, so I was wondering if there is a way to convert the rn back to \r\n.

Thanks,
Justin

[bpat1434]

um... they shouldn't. mysql_real_escape_string() should turn \r\n into \r\n because it escapes (prepends a \ ) the next character. The special characters, like \ * " ', all need escaping. So your \r\n shouldn't be rewritten as rn. My guess is, you might have a stripslashes call in there that does this.

Post some relevant code, and we may be able to help you further

~Brett

[Shroder]

That info helped me a lot actually. I was looking at the wrong section of code, and it ended up being a problem with stipslashes.

Thanks!

[bpat1434]

No problem, glad I could be of help!!