PHP Problem or MySQL (Match ... against)?
| From: | jtjohnston | Date: | Mon, 02 Dec 2002 20:19:20 +0000 |
| Subject: | PHP Problem or MySQL (Match ... against)? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-126754@lists.php.net to get a copy of this message | ||
I'm stuck. I have been to the MySQL lists for this.
Now I'm reconsidering my PHP code.
http://ccl.flsh.usherb.ca/print/display.table.inc.phps
I just don't know where I'm going wrong anymore.
If I run this SQL in PHPMyAdmin, it works. jdaxell.ccl should have one
entry for "ready maria".
SELECT id,AU,ST,BT,AT FROM jdaxell.ccl 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
When I run the same (copied and pasted) SQL in PHP, it is as though
MySQL is doing a boolean search for
+ready +maria without the double
quotes and finding results in every database. if you search for "ready
maria" it should only find one entry.
http://ccl.flsh.usherb.ca/print/index.html?search=%26quot%3Bready+maria%26quot%3B
So what have I done wrong now :(
John