RE: [PHP] strip single quotes

2003-03-20 Thread Daniel McCullough
store_address WHERE address = '".$address."'"; any thoughts From: "John W. Holmes" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "'Daniel McCullough'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Subject: RE: [PHP]

RE: [PHP] strip single quotes

2003-03-20 Thread Daniel McCullough
sult2); $sql3 = "SELECT * FROM store_address WHERE address = '".$address."'"; any thoughts From: "John W. Holmes" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "'Daniel McCullough'" <[EMAIL PROTECTED]>,<[EM

RE: [PHP] strip single quotes

2003-03-19 Thread John W. Holmes
> I'm trying to query the database using a string pulled out of the database > and compare and get the id. I can do it to a certain point and what kills > my query is single quotes. I CANNOT figure out how to escape it. > > I DID THIS: > $address2 = str_replace("'", "", $address); > > that work

RE: [PHP] strip single quotes

2003-03-19 Thread Martin Towell
try this $address2 = str_replace("'", "''", $address) -Original Message- From: Daniel McCullough [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 1:48 PM To: [EMAIL PROTECTED] Subject: [PHP] strip single quotes I'm trying to query the database using a string pulled out of the dat