Re: explode () and mySQL query

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