how to write query based on array values

Question

I have an array of employee ids:

34 , 35, 40, 67, 54 and so on.

What would be the simplest way to query my 'employees' table and find all the names of the correlated employees?

That is a query that would return the 'name' for each of the ids in the array.

code_burgar · Accepted Answer · 2009-08-30 16:43:53Z

5

$id_str = implode(', ', $ids);
mysql_query("SELECT name FROM employees WHERE id IN ($id_str)");

If you want them all in one result row, use mysql's GROUP CONCAT.

answered Aug 30, 2009 at 16:43

code_burgar

12.3k4 gold badges37 silver badges53 bronze badges

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

Comments

Sampson · Accepted Answer · 2009-08-30 16:42:24Z

2

Implode your array into a string, and then use the IN() function of MySQL.

SELECT col1, col2, col3
FROM employees
WHERE col1 IN(1, 12, 38, 52)

You can get that in string with implode()

$ids = array(1,132,32,52);
$inString = implode(",",$ids);

$query = "SELECT col1, col2, col3
          FROM employees
          WHERE col1 IN ({$inString})";

answered Aug 30, 2009 at 16:42

Sampson

269k76 gold badges546 silver badges570 bronze badges

Collectives™ on Stack Overflow

how to write query based on array values

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