escaped words returning escaped?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

escaped words returning escaped?

Post by GeXus »

Is it posible to escape text and not have to escape it again on select?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post 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.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

Yah, that's what i've always done.. but for some reason when I select now, it is escaped.. ie, that/'s
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

sounds like you have magic quotes enabled, which is a bad thing.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

They are being escaped twice.

get_magic_quotes_gpc() may be needed.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

Ahh.. okay I bet that's it.. thank you!
Post Reply