I am getting the following error when running the query through php my admin: MySQL said: Documentation #1191 - Can't find FULLTEXT index matching the column list I am new to this; Thank you for the help. Ron On Wed, 2008-05-28 at 22:01 -0400, Ron Piggott wrote: > Someone referred me to: > > http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html > > Does this look like I am on the right track? > > Ron > > SELECT MATCH(shopping_cart_product.product_description, > shopping_cart_product.product_name) AGAINST ('$keyword') as Relevance > FROM ( shopping_cart_category INNER JOIN shopping_cart_product ON > shopping_cart_category.reference = > shopping_cart_product.category_reference ) INNER JOIN > shopping_cart_product_image ON > shopping_cart_product_image.product_reference = > shopping_cart_product.reference INNER JOIN shopping_cart_inventory ON > shopping_cart_inventory.product_reference = > shopping_cart_product.reference WHERE MATCH > (shopping_cart_product.product_description, > shopping_cart_product.product_name) AGAINST('$keyword' IN BOOLEAN MODE) > HAVING Relevance > 0.2 ORDER > BY Relevance DESC -- ron.piggott@xxxxxxxxxxxxxxxxxx www.actsministrieschristianevangelism.org Acts Ministries Christian Evangelism "Where People Matter" 12 Burton Street Belleville, Ontario, Canada K8P 1E6 In Belleville Phone : (613) 967-0032 In North America Call Toll Free : (866) ACTS-MIN Fax: (613) 967-9963 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
