[PHP-DB] Re: explode () and mySQL query

[Ron Piggott]

I am not sure why this isn't bringing any results:

WHERE shopping_cart_product.product_description IN ('straying')

The word straying is in the midst of one of the descriptions.  

Ron

On Wed, 2008-05-28 at 20:13 -0400, Ron Piggott wrote:
 I am trying to add a search feature to my shopping cart.
 
 I am wanting to use PHP to develop the query for mySQL.  I have the
 following code figured out:
 
 foreach(explode( , $keyword) as $key) $query .=  $key, ;
 
 This produces:
 
 WHERE shopping_cart_product.product_description IN ( Jesus, is, Lord, )
 
 The weakness is the trailing , after the last word the user types in.
 
 How can I eliminate this?
 
 Ron
-- 
[EMAIL PROTECTED] 
www.actsministrieschristianevangelism.org 

Acts Ministries Christian Evangelism 
Where People Matter 
12 Burton Street 
Belleville, Ontario, Canada   K8P 1E6 
 
In Belleville Phone : (613) 967-0032 
In North America Call Toll Free : (866) ACTS-MIN 
Fax: (613) 967-9963 


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

[PHP-DB] Re: explode () and mySQL query

[Chris]

Ron Piggott wrote:
 I am not sure why this isn't bringing any results:
 
 WHERE shopping_cart_product.product_description IN ('straying')
 
 The word straying is in the midst of one of the descriptions.  

Ahh, oops - didn't notice that before.

IN() looks for specific entries, so unless the entry is straying and
*only* straying it will not be found.

You can either use full text indexes
(http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html) or like
searches:


where description like '%straying%' or description like '%another word%';

full-text works best on a big, random database (if you have a lot of
keywords that are the same it won't work very well).

-- 
Postgresql  php tutorials
http://www.designmagick.com/

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