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 in the index.  My index is named
product_description_search

Would someone show me a sample query from the table?  I have tried to
get this to work during the past half hour and I don't understand this
type of query yet.  

Where I am at with my search query that doesn't work is:

SELECT MATCH ( 'product_description_search') AGAINST ( 'Jesus') FROM
shopping_cart_product

Thanks, Ron

On Fri, 2008-05-30 at 21:58 -0400, Bastien Koert wrote:
> 
> 
> 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