Page 1 of 1

Mystery "rn" showing up in text that comes from da

Posted: Tue Nov 28, 2006 12:07 pm
by Luke
For some reason "rn" is being appended to the end of a small description I am pulling out of my database. I can't figure out where it's coming from. It's not from the template... it's not in the database... is rn significant to anybody?

Posted: Tue Nov 28, 2006 12:18 pm
by redmonkey
A Windows carriage return after being passed through stripslashes?

Posted: Tue Nov 28, 2006 12:19 pm
by Popcorn
SQL from PHP INSERTing '\r\n' into the db which is an escaped sequence and so ends up in the db as 'rn' ?? ....

Posted: Tue Nov 28, 2006 12:35 pm
by Luke
yea that's probably it. thanks!

So what should I be passing it through if not stripslashes?

Posted: Tue Nov 28, 2006 4:23 pm
by feyd
You shouldn't need to stripslashes() data coming out of the database. If you do, then you likely have a double call to addslashes() or the like when it's being put in.

Posted: Tue Nov 28, 2006 4:32 pm
by Luke
thanks feyd... I do in fact have that.