Re: [PHP-DB] Searching shopping cart

> Would someone show me a sample query from the table?  I have tried to
> get this to work during the past half hour and I don't understand this
> type of query yet.  
> 
> Where I am at with my search query that doesn't work is:
> 
> SELECT MATCH ( 'product_description_search') AGAINST ( 'Jesus') FROM
> shopping_cart_product

You don't use the index name in the match, you use the columns you want
to search.

select match(col1, col2) against('keyword') from tablename;

As mentioned in the mysql manual:

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

-- 
Postgresql & php tutorials
http://www.designmagick.com/