Full-text, Match() problem.... Please help...

runelore

Hi I have this code to search my DB.. The problem is that it pays no attention to what '$name' is and only filters according to '$address'. I have the indexes set up fine, there is no problem with the database... Can anyone please help.... Thanks...

$result=mysql_query("SELECT *, MATCH (name,category,keywords,town,county) AGAINST ('$name') from details where MATCH (town,county) AGAINST ('$address')");

[deleted]

$query="SELECT *, MATCH (name,category,keywords,town,county) AGAINST ('$name') as name from details where MATCH (town,county) AGAINST ('$address')";
$result=@msyql_query($query,$link);
try this........

jeremuck

looks like your query needs some syntax help.

did you look in the documentation at www.mysql.com?

"SELECT *, MATCH (name,category,keywords,town,county) AGAINST ('$name') from details where MATCH (town,county) AGAINST ('$address')"

should be more like

"SELECT *, MATCH (name,category,keywords,town,county) AGAINST ('$name $address') as scores from details where MATCH (town,county) AGAINST ('$address')"

what exactly are you trying to do?
and why bother using fulltext search for this?

runelore

It is a search engine for a website.... www.kermin.com
the reason for full-text search is that I want to be able to search on full words and not just parts of words.. I tried to use REGEXP functions to do this but had no luck.... if there is a better way, I would be pleased to know.... thanks for the reply and help...