Page 1 of 1

escaped words returning escaped?

Posted: Sun Mar 18, 2007 10:05 am
by GeXus
Is it posible to escape text and not have to escape it again on select?

Posted: Sun Mar 18, 2007 11:06 am
by John Cartwright
Huh?

You mean escaping quotes? On insertion, mysql_real_escape_string() is used, and upon selecting, you select it normally.

Not sure what your problem is.

Posted: Sun Mar 18, 2007 11:52 am
by GeXus
Yah, that's what i've always done.. but for some reason when I select now, it is escaped.. ie, that/'s

Posted: Sun Mar 18, 2007 11:55 am
by John Cartwright
sounds like you have magic quotes enabled, which is a bad thing.

Posted: Sun Mar 18, 2007 11:55 am
by feyd
They are being escaped twice.

get_magic_quotes_gpc() may be needed.

Posted: Sun Mar 18, 2007 4:27 pm
by GeXus
Ahh.. okay I bet that's it.. thank you!