Which version of mysql are you using? -- Ray
On Wed, 2002-12-04 at 10:33, John Taylor-Johnston wrote: > 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
