Searching shopping cart

From: Date: Thu, 29 May 2008 02:01:01 +0000
Subject: Searching shopping cart
Groups: php.db 
Request: Send a blank email to php-db+get-45011@lists.php.net to get a copy of this message
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

« previous php.db (#45011) next »