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

O/H Ron Piggott ??????:
> 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
>
>
>   
You can alternative use implode which I think is a much better choice 
because it does exactly what you need.
You can use it like this

$keys = implode(",",$keyword);
$query .= $keys;

This is the reference in the manual:
http://gr2.php.net/manual/en/function.implode.php

-- 
Thodoris