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 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
>
> Ron,

You can't create a multi-col full text index. You should only create it on
the long text field




-- 

Bastien

Cat, the other other white meat