Re: Whimper, help :)

From: Date: Wed, 04 Dec 2002 05:12:41 +0000
Subject: Re: Whimper, help :)
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-126938@lists.php.net to get a copy of this message
Tom, Anyone, No I'm not looking for a ", I'm trying to pass double quotes into MySQL. Like I said, it works when debugging: http://ccl.flsh.usherb.ca/print/print.html?search=%26quot%3Bready+maria%26quot%3B http://ccl.flsh.usherb.ca/print/display.test.inc.phps but fails when I try to pass my double quotes in: http://ccl.flsh.usherb.ca/print/index.html?search=%26quot%3Bready+maria%26quot%3B http://ccl.flsh.usherb.ca/print/display.table.inc.phps $sql = "SELECT id,AU,ST,BT,AT FROM $table WHERE MATCH (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('".stripslashes($search)."' IN BOOLEAN MODE) ORDER BY id asc"; I already have the <input type=text name=search> $search I have tried many variations. > If you are looking for " in a string just quote it with ' > example > $like = '"ready maria"'; > $ sql = " SELECT .......... WHERE .... LIKE '$like'"; > no need to escape anything

« previous php.general (#126938) next »