Re: I will not eat them Sam-I-Am
| From: | Hugh Bothwell | Date: | Thu, 16 Aug 2001 02:18:06 +0000 |
| Subject: | Re: I will not eat them Sam-I-Am | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-62935@lists.php.net to get a copy of this message | ||
"Justin" <kgb@graffitilandscape.com> wrote in message
news:NFBBLLHMALGFBKEPPKHAGEOLCEAA.kgb@graffitilandscape.com...
> INSERT INTO database VALUES( 'bill's bowtie');
Bad syntax: try
INSERT INTO database ( fieldname ) VALUES ( 'this string' )
> and then I want to feed it back into phpMyAdmin it gives me an error.
> Basically, it's confused by the middle apostrophe. So how can I dump this
> statement back into phpMyAdmin other than by manually adding a slash
before
> each apostrophe that will confuse it?
AddSlashes()
NOTE that MySQL will interpret these and
turn the string back to the original internally,
so there is no need to StripSlashes() when
retrieving the string.