MySQL in() multidimensional array

Question

the following works (array is filled in by another MySQL query):

$array=(1,4,5,6,8);
$query=SELECT * FROM table WHERE Id IN(".implode(",",$array)."

But how can I do the following?:

$array=(
array('Id'=>1, 'Detail1'=>$row['Detail1'], 'Detail2'=>$row['Detail2']),
array('Id'=>4, 'Detail1'=>$row['Detail1'], 'Detail2'=>$row['Detail2']),
array('Id'=>5, 'Detail1'=>$row['Detail1'], 'Detail2'=>$row['Detail2']),
array('Id'=>6, 'Detail1'=>$row['Detail1'], 'Detail2'=>$row['Detail2']),
array('Id'=>8, 'Detail1'=>$row['Detail1'], 'Detail2'=>$row['Detail2']),
);
$query=SELECT * FROM table WHERE Id IN(".implode(",",$array[]['Id'])."

So i need to get all the id's, how can I do that in this multidimensional array?

Thanks!

Brian Glaz · Accepted Answer · 2012-01-12 16:01:05Z

6

I would just do something like this:

$id_list = array();

foreach($array as $item) {
 $id_list[] = $item['Id'];
}

$query = "SELECT * FROM table WHERE Id IN(".implode(',',$id_list).")";

answered Jan 12, 2012 at 16:01

Brian Glaz

15.7k4 gold badges40 silver badges55 bronze badges

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

Comments

Wrikken · Accepted Answer · 2012-01-12 16:09:13Z

1

Another option:

$list = array_reduce($id_list,function($total,$cur_value){
     if(!is_null($total)) $total .= ',';
     return $total.$cur_value['id'];
  });
$query = "SELECT * FROM table WHERE Id IN(".$list.")";

answered Jan 12, 2012 at 16:09

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Collectives™ on Stack Overflow

MySQL in() multidimensional array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related