Re: single quotes in database

From: Date: Fri, 07 Nov 2003 16:58:17 +0000
Subject: Re: single quotes in database
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-168873@lists.php.net to get a copy of this message
also check magic_quotes_runtime in php.ini. This add's slashes to incoming Post/get variables You can change this at tun time with the ini_set() function pete Steve Buehler wrote:
I am using PHP/MySQL and am having a problem. We have some names and addresses in the database that have single quotes in them. For instance. There is a town around here called "Lee's Summit". Also names like "O'connel". When I pull from the database it skips these because of the quotes. I know there is something that I have seen before about this, but can't find it now. Can anybody help me? I really hope this makes since because I am sick today and am having a hard time thinking straight. Is it something that I will have to fix when putting things into the database? I am hoping on being able to fix this when going in and when coming out of the database so that I don't have to go back and redo all the ones that are already in the database. Thanks Steve


« previous php.general (#168873) next »