Re: Whimper, help :)
| From: | John Taylor-Johnston | Date: | Wed, 04 Dec 2002 06:28:22 +0000 |
| Subject: | Re: Whimper, help :) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-126946@lists.php.net to get a copy of this message | ||
http://ccl.flsh.usherb.ca/print/print.html?search=%26quot%3Bready+maria%26quot%3B
http://ccl.flsh.usherb.ca/print/index.html?search=%26quot%3Bready+maria%26quot%3B
I blame PHP. Can't be MySQL.
echo $sql displays the EXACT same thing.
Debugging ... Works jdaxell.ccl = 2 records found:
$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 (\'"ready maria"\' IN BOOLEAN MODE) ORDER BY id asc';
http://ccl.flsh.usherb.ca/print/display.test.inc.phps
Doesn't work - Resembles +ready +maria
$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";
http://ccl.flsh.usherb.ca/print/display.table.inc.phps
Doesn't work - Resembles +ready +maria
$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";
http://ccl.flsh.usherb.ca/print/display.table.inc.phps
Doesn't work - Resembles +ready +maria
$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';
http://ccl.flsh.usherb.ca/print/display.table.inc.phps
:0
John