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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php