Posted by Richard Davey on 01/06/05 13:23

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

• Next in thread: Re: [PHP] Re: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] SELECT probrem
• Next in forum: Re: Form to email with Special Characters
• Prev in forum: Re: [PHP] Removing all <tr> tag
• Thread view: Re: [suspicious - maybe spam] [PHP] [suspicious - maybe spam] SELECT probrem

[Reply to this message]