Re: PHP Problem or MySQL (Match ... against)?

Chris, or anyone, I have tried to escape the slashes. Debugging ... $sql = 'SELECT ... ... AGAINST (\'"ready maria"\' IN BOOLEAN MODE) ...'; This works. But if I addslashes or stripslashes, or do nothing, it does not work. See these 3 variations. Neither work. What should I do? A part from hang myself :) $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 (\''.addslashes($search).'\' IN BOOLEAN MODE) ORDER BY id asc'; $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'; $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 (\''.$search.'\' IN BOOLEAN MODE) ORDER BY id asc'; John > > SELECT id,AU,ST,BT,AT FROM jdaxell.ccl 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 > > > > When I run the same (copied and pasted) SQL in PHP, it is as though > > MySQL is doing a boolean search for +ready +maria without > > the double > > quotes and finding results in every database. if you search for "ready > > maria" it should only find one entry. > > Escape the double quotes. ('\"ready maria\"' IN BOOLEAN .... > > g.luck, > ~Chris