Re: Whimper, help :)
| From: | John Taylor-Johnston | 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