Issue with MySQL Fulltext and MySQL_query function not working??

[JonathanAnon]

i,

I have just got a dedicated server for my online directory.
I have changed the ft_min_word_len to a value of 2, have rebooted the server and have checked the "Show variables like 'ft_min_word_len';" and this returns a value of 2. I have also reindexed the records. When I run MySQL (through Putty),

select * from businesses WHERE (MATCH (businessname, keywords) AGAINST('car'));

this returns 10 records.

But when I use the exact same query using,

include('opendb.php');
$sql = "select * from businesses WHERE (MATCH (businessname, keywords) AGAINST('car'))";
$result=mysql_query($sql,$db);
$num=mysql_num_rows($result);

etc etc.

it returns nothing. I know there is nothing wrong with the code as the same code using a searchstring of four or more characters it works fine. It just seems that the mysql_query statement does not work on less than four characters even though I have changed it.. Has anyone got any ideas as this is driving me mad.

thanks
J

[bogu]

Try like this:

$sql = "select * from businesses WHERE (MATCH (`businessname`, `keywords`) AGAINST('car'))";

[JonathanAnon]

Hi I'm not sure that you understand the nature of the problem.

The query works fine if I use the following query (i.e. cars - 4 characters as opposed to car - 3 characters)

$sql = "select * from businesses WHERE (MATCH (businessname,keywords) AGAINST('cars'))";

The default Full Text searching ignores 1, 2 and 3 character searches. I have changed this, the system tells me that ft_min_word_len is 2 and when I run a query through phpMyAdmin or from the mysql prompt it works, BUT NOT WHEN I USE MYSQL_QUERY.

thanks,
J

[bogu]

yes I understand your problem and I change this part of your code:

businessname, keywords

When u execut queries using phpmyadmin or something similar they change your code like I changed it, I think the problem is that word keywords is a special mysql word and the server doesnt know how to interpret it ...

That's why I use this " ` " character for your fields name ...