Hi, Can someone take a look at this again, please?
http://news.php.net/article.php?group=php.general&article=126934 Your posts so far have proven fruitless. Thanks for trying. :) I do appreciate it. I will try to answer everyone at the same time. Someone mentionned it might be a problem with magic_quotes, but I didn't really follow. http://news.php.net/article.php?group=php.general&article=126990 I did test what he suggested: >From John Holmes > try this Doesn't work. :) Thanks. I did try: $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"; It echos: ('\"ready maria\"' IN BOOLEAN MODE) It should echo: ('"ready maria"' IN BOOLEAN MODE) for it to work. But even if I add slashquotes, it won't do it. -------------------------------------------------------------------------------------------------------------- >could you get the error message with mysql_error() and post it here? There is no error. I wish there was :) Thanks for trying. >Doesn't work - Resembles +ready +maria >hmm - how do you get your string "ready maria"? <input name=search> >why '.$table.' and not '".$table."' >with what you've got now, I believe you are looking for table name. Good idea. Done that. Doesn't change . :) Thanks. >also, use double quotes for start and end of variables as in: >$sql="select * from '".$table."' where var='some >value other than a number' "; Doesn't work. :) Thanks. John -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
