up vote 1 down vote favorite
1
 
$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.

share|improve this question

4 Answers

up vote 2 down vote accepted

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.

share|improve this answer
up vote 2 down vote 
$skuArray = array('00240'=>123,'00241'=>456);
$keys = array_keys($skuArray);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN('" . join("','", $keys) . "')");
share|improve this answer
Cant get this to work :( – Ezra Jun 25 '11 at 13:05
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. – Andreas Jansson Jun 25 '11 at 13:12
up vote 0 down vote 
 foreach($skuArray  as $value=>$key){
    if($where=="")
       $where= $value" = '".$key."'";
    else
       $where.= $value" = '".$key."'";
 }
 $getSkus = mysql_query("SELECT sku FROM data " .($where)?" WHERE   $where )":"");
share|improve this answer
up vote 0 down vote 
$skuArray = array('00240'=>123,'00241'=>456);
$keys = array_keys($skuArray);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN ('" . join("','", $keys) . "')");

@Andreas, Ezra: there was no space between IN and (. That's why it's probably not working. I don't have edit privileges yet, so had to do it here...

share|improve this answer

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.