> Hello Phpu,
> 
> Thursday, January 6, 2005, 10:42:15 AM, you wrote:
> 
> P> I have an array, for ex: $products=array(1, 2,  5 , 7)
> P> I want to select all products from the database that has the ids of 
> products.
> P> I use this but doesn't work:
> 
> $product_ids = implode(',', $products);
> $sql = "SELECT product_name FROM accessories WHERE product_id IN 
> ($product_ids)";
> 
> Best regards,
> 
> Richard Davey

Slightly off topic but worth mentioning is:

If your $products array is generated dynamically, make sure it isn't
empty before running the query, MySQL does NOT like:

"SELECT product_name FROM accessories WHERE product_id IN ()"

The empty "()" will cause a MySQL error (it won't just return an empty
result set.)  Plus, why run the query if the array is empty anyway?

/jw

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

Reply via email to