Re: [PHP-DB] Searching shopping cart

I don't understand what is going wrong:

CREATE FULLTEXT INDEX
ON shopping_cart_product(product_name, product_description) 

gives me this error:

#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ON shopping_cart_product(product_name,
product_description)' at line 1

My table is named: shopping_cart_product

I have columns: 

product_name varchar(50)
product_description longtext

Ron

On Thu, 2008-05-29 at 12:48 +1000, Chris wrote:
> Ron Piggott wrote:
> > 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
> 
> Grr - stupid manual didn't have a link on how to create the index.
> 
> http://dev.mysql.com/doc/refman/5.0/en/create-index.html
> 
> create fulltext index on table(field1, field2);