PHP/mySQL - Select WHERE multiple values in an associative array

Question

$skuArray = array(00240=>123,00241=>456);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN($skuArray)");

My above code doesn't work, how can I make it SELECT all sku's FROM data WHERE sku = any of the key names in $skuArray? (00240 and 00241 in this case)

Hope this makes sense, Thank You.

Jan · Accepted Answer · 2011-06-25 12:38:57Z

2

Try this:

<?php
$skuArray = array('00240'=>123, '00241'=>456);

$inSkus = array();

foreach (array_keys($skuArray) as $key)
{
    $inSkus[] = '"' . $key . '"';
}

$sql = 'SELECT sku FROM data WHERE sku IN (' . implode(', ', $inSkus) . ')';

echo $sql;

You need to have the keys as strings and you then need to wrap them in parentheses for the SQL query.

answered Jun 25, 2011 at 12:38

Jan

2,2931 gold badge17 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andreas Jansson · Accepted Answer · 2011-06-25 12:36:29Z

2

$skuArray = array('00240'=>123,'00241'=>456);
$keys = array_keys($skuArray);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN('" . join("','", $keys) . "')");

answered Jun 25, 2011 at 12:36

Andreas Jansson

3,3073 gold badges33 silver badges44 bronze badges

1 Comment

Andreas Jansson Over a year ago

What's not working? Are the array keys wrapped in quotes, otherwise PHP reads them as octals. Is $skuArray NULL? In that case you'll get an error on line 2. You should probably check that $skuArray is not empty as well.

Rajasekar Gunasekaran · Accepted Answer · 2011-06-25 12:47:06Z

0

 foreach($skuArray  as $value=>$key){
    if($where=="")
       $where= $value" = '".$key."'";
    else
       $where.= $value" = '".$key."'";
 }
 $getSkus = mysql_query("SELECT sku FROM data " .($where)?" WHERE   $where )":"");

edited Jun 25, 2011 at 12:47

answered Jun 25, 2011 at 12:40

Rajasekar Gunasekaran

1,8393 gold badges27 silver badges43 bronze badges

Collectives™ on Stack Overflow

PHP/mySQL - Select WHERE multiple values in an associative array

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related