Re: Tom: [PHP] magic quotes

2002-12-04 Thread Tom Rogers
Hi, Thursday, December 5, 2002, 7:11:20 AM, you wrote: JTJ> Tom, JTJ> Sorry for the delay. I have tried your code. JTJ> SELECT id,AU,ST,BT,AT FROM ccl_main WHERE MATCH JTJ> (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST ('"ready maria" ' IN BOOLEAN MODE) JTJ> ORDER BY id asc

Tom: [PHP] magic quotes

2002-12-04 Thread John Taylor-Johnston
Tom, Sorry for the delay. I have tried your code. SELECT id,AU,ST,BT,AT FROM ccl_main 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 Without the space, as with addslashes, MySQL won't compute the sql. This is th