[Fulltext Search?]

Stuart, thank you!!! That's just what I needed. Can you give any insight into the relevance issue, i.e. matching two search terms without being an "exact" match?

 

Chris

[Fulltext Search?]

Hi everyone. I haven't posted in months, not since the new forum which looks great, btw.

 

I need my search query to return results by a search phrase, not just each individual word in a query. Chapter 6 discusses FULLTEXT searches using WHERE...MATCH but my query returns everything instead of just what I want. For example, searching for Bonn Forceps returns all products by Bonn, and all forceps by every doctor.

 

http://stephensinst.com/products.php

 

Here is my query:

 

$q = "SELECT * FROM products, doctors, types, subtypes WHERE doctors.doc_id = products.doc_id AND types.type_id = products.type_id AND subtypes.sub_id = products.sub_id AND MATCH (description) AGAINST ('%$find%') ORDER BY prod ASC";

 

I added FULLTEXT index to the products, doctors, types, and subtypes tables. Can someone tell me what I'm doing wrong?

 

Thanks!

 

Chris