Re: Apostrophe problem on Firebird
| From: | CPT John W. Holmes | Date: | Thu, 06 Nov 2003 14:40:54 +0000 |
| Subject: | Re: Apostrophe problem on Firebird | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31477@lists.php.net to get a copy of this message | ||
From: "Evan Morris" <evan@exclusivebooks.com>
> I have data in a database that may contain apostrophes.
Some databases use the backslash character as an escape character for single
quotes, while others use another single quote. Try your query such as:
SELECT * FROM Table WHERE name = 'o''mallery'
Instead of using addslashes(), you'll need to do a simple str_replace to
escape the characters.
---John Holmes...