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 ï»

Re: [PHP-DB] Searching shopping cart

On 5/30/08, Ron Piggott <[EMAIL PROTECTED]> wrote: > > > 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

Re: [PHP-DB] Searching shopping cart

Ok. I have the index created. ALTER TABLE `shopping_cart_product` ADD FULLTEXT ( `product_description`,`product_name` ) is what worked --- I think the web site http://dev.mysql.com/doc/refman/5.0/en/create-index.html was assuming the creation of a new table. I am able to have both columns i