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); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
