[RESOLVED] Full text search

[mckintosh18]

Im working on my website and i want a to have a search engine using full text search im using phpmyadmin heres my code

<?
$username="root";
$password="";
$database="mydata";
$search=$_POST['search'];
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT name, age, address, zip, phone FROM member WHERE MATCH(name, age, address, zip, phone) AGAINST ('$search')";

$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {

$search=mysql_result($result,$i,"name");

echo "Name:<b>$search<hr><br>";

$i++;
}

?>

first problem it gives warning and second it doesnt give any results can u pls tell me whats wrong. all of my fields in the database were set to FULL TEXT INDEX

[future448]

1. What is the warning shown, because this is probably your problem?

2. Change $result=mysql_query($query); to:

   $result=mysql_query($query) or die(mysql_error());
   

   Because that will tell you if there was a problem with your query.

3. Change:

   $num=mysql_numrows($result);
   

   To:

   $num=mysql_num_rows($result);
   

   Which is 'probably' your problem.

[mckintosh18]

thanks for that, but now that ive changed what you told me to change now im receiving this

"Can't find FULLTEXT index matching the column list"

what could it be thanks

[future448]

Well I have never used full text searching before so I am no expert.

The manual says that:

The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table

So I would ensure that when you created / altered your table you exactly used the same columns when defining FULLTEXT as you are now searching for.

Judging by a quick Google search this appears to be the common problem for this error.

[bradgrafelman]

As the error clearly states, your column list in the MATCH() statement doesn't list any indexes you've created. So, all you need to do is to create a FULLTEXT index on the columns you're wanting to search on.

Note that 5 FULLTEXT indexes on 5 columns is not the same as (nor will it work the same as) 1 FULLTEXT index on 5 columns.

[mckintosh18]

ok but now im getting this results "Resource ID # 2"

[bradgrafelman]

Show us the code you're using that gave you that message.

[mckintosh18]

i already figure it out and its already working but how can i search words less than 3 letters.

[mpb001]

ft_min_word_len sets the min word length

Needs to be set in the my.cnf/my.ini and when changed the index needs to be rebuilt.

Info here
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

Also read about the stopword file as in some cases it may give you problems so you should be aware of it.