Re: RE: USING PHP to add ' to SQL
| From: | Stas Trefilov | Date: | Fri, 28 Jul 2000 07:51:55 +0000 |
| Subject: | Re: RE: USING PHP to add ' to SQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-1368@lists.php.net to get a copy of this message | ||
Flint Doungchak wrote:
> UPDATE events set starttime = '20000820 12:40',event='Flint""s Dorkey
> Stuff' where
> eventid='1'
> select * from events
>
> returns Flint""s Dorkey Stuff
>
> which is dumb since I now have to strip out the extra quote. Any ideas?
You got to use '' for ' only, you don't have to type " twice.
--
Stas Trefilov
Moscow Russia