One question that comes up is why are you putting the double quotes around the search string ready maria? Should there be an entry in the database that includes the double quotes. Right now that is what your sql statement is looking for. So an entry like this
Are you ready maria? Would not be found but an entry like The book "ready maria" is great Would return something. Robbert van Andel -----Original Message----- From: John Taylor-Johnston [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:33 AM To: [EMAIL PROTECTED] Subject: [PHP] Sigh :) 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
