[snip]
> As far as I can see, *none* of these produce an identical query string to
> your hard-coded version -- they *all* have the double-quotes around the
> search string missing!
The double quotes are in $search, that's why. And the stripslashes is there
more than likely because of magic_quotes_gpc, which will make $search equal
to \"ready maria\"
What if you do it this way?
$search = '"ready maria"';
$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";
Does that work?
Are you sure the quotes you enter in the box aren't being converted to
" or %XX or something, and then causing your query to fail or return
odd results?
---John Holmes...
> Try this:
>
> $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';
>
> (BTW, I'm not sure you need the stripslashes() -- I don't use MySQL, so I
> can't be sure, but doesn't it need quotes to be backslash-escaped inside a
> quoted string?)
>
> Cheers!
>
> Mike
>
> ---------------------------------------------------------------------
> Mike Ford, Electronic Information Services Adviser,
> Learning Support Services, Learning & Information Services,
> JG125, James Graham Building, Leeds Metropolitan University,
> Beckett Park, LEEDS, LS6 3QS, United Kingdom
> Email: [EMAIL PROTECTED]
> Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
>
> --
> 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
