Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
GeXus
- Forum Regular
- Posts: 631
- Joined: Sat Mar 11, 2006 8:59 am
Post
by GeXus »
Is it posible to escape text and not have to escape it again on select?
-
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
-
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.
-
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!