Re: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] SELECT probrem
| From: | Richard Davey | Date: | Thu, 06 Jan 2005 11:23:05 +0000 |
| Subject: | Re: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] SELECT probrem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-205722@lists.php.net to get a copy of this message | ||
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
--
http://www.launchcode.co.uk - PHP Development Services
"I am not young enough to know everything." - Oscar Wilde