Full-Text not working with mysql_query() function
No replies to this topic
Posted 07 March 2006 - 08:34 PM
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,
$sql = "select * from businesses WHERE (MATCH (businessname, keywords) AGAINST('car'))";
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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users