I don't understand what is going wrong:

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


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);

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to