OK, I think I've solved this, and you'll probably kick yourself when I explain it!"  
But first, a teaser:  what looks like a double-quote in HTML, but isn't?

>-----Original Message-----
>From: John Taylor-Johnston

> If I run the SQL in PHPMyAdmin, (a MySQL web interface), it works.
> 
> jdaxell.ccl = 2 records found.
> 
> 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
> 
> But try to pass it through PHP - zippo. MySQL thinks it is a boolean
> search for
> +ready +maria
> not an exact search for the two words together
> 
> "ready maria"
> 
> MySQL does not see the double quotes. It should. Somehow, PHP is
> thwarting them?

Not PHP, your browser, I suspect.  In fact there are no quotes there!  No, donm't yell 
at me, there really aren't!!

Close inspection of the source of your "non-working" result reveals that what it has 
actually searched for is "ready maria" -- which, of course, displays on the 
screen as "ready maria", with the HTML " entities converted to double quotes!  Of 
course, as the $search variable actually contains the version with the " 
entities, this is what MySQL sees, and duly regards it as a non-quoted string 
contining the words quot, ready and maria, and a few non-significant punctuation marks!

What I think is happening is that your browser is encoding certain characters in the 
form field into HTML entities before submitting them -- so to get PHP to see them 
correctly, you're going to need to unencode any HTML-entities in the string in your 
$search variable.  I suggest a quick visit to the manual page for html_entity_decode 
(http://www.php.net/html-entity-decode) may be in order (this function is not 
available until PHP 4.3.0, but the manual page does give a pre-4.3.0 alternative).

(Of course, don't forget to keep the HTML-entities version for echoing back to your 
HTML results page!)

This was a neat one -- hope this analysis helps!

Cheers!

Mike

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to