> 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
