Use an array inside a query string

Question

Im trying to pass an array that I already found by a query into another query. For example:

$first_query = "SELECT id FROM from Table WHERE user = '{$_SESSION['id'}'";
$result = mysql_query($first_query,$connection);
$ids = mysql_fetch_array($result);

This is where it gets tricky for me. I want to pass $ids into the next query.

$id_implode = implode(", ", $ids)
$second_query = "SELECT * FROM Table2 WHERE id = '{$id_implode}';

The second query doesnt seem to be working. Any help is greatly appreciated!

tomfumb · Accepted Answer · 2011-06-09 22:23:44Z

5

your second query's syntax is wrong. Once evaluated it should read

select * from Table2 where id in (1,2,3)

ditch the curly braces and change the = to in. Don't use OR - that's a dumb way of ignoring good sql functionality

EDIT: Teneff's comment makes a very good point - why are you approaching the problem in this way? If there is a relationship between the tables they can be joined and all the data you want can be retrieved in a single query. If for some reason you can't / won't join the tables you could at least try a sub-query

select * from table2 where id in (select id from table where user = $_SESSION['id']);

edited Jun 9, 2011 at 22:23

answered Jun 9, 2011 at 21:53

tomfumb

3,7693 gold badges38 silver badges51 bronze badges

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

Comments

Paul DelRe · Accepted Answer · 2011-06-09 21:55:16Z

1

To use a where statement with multiple entries to match on, use in ().

$id_implode = "'".implode("', '", $ids)."'"
$second_query = "SELECT * FROM Table2 WHERE id in ({$id_implode});

answered Jun 9, 2011 at 21:55

Paul DelRe

4,0392 gold badges26 silver badges27 bronze badges

Comments

Nicola Peluchetti · Accepted Answer · 2011-06-09 21:55:17Z

1

I think you should use IN

$id_implode = implode(", ", $ids)
$second_query = "SELECT * FROM Table2 WHERE id IN '({$id_implode})';

This assumes that $ids is made of int of course, otherwise you have to enclose eache entry in quotes. that means

IN (6,7,8,9)//this doesn't need quotes

IN ('lemon', 'orange')//needs quotes

answered Jun 9, 2011 at 21:55

Nicola Peluchetti

76.9k32 gold badges150 silver badges197 bronze badges

Comments

Dan Soap · Accepted Answer · 2011-06-16 20:15:03Z

1

try to use the IN syntax:

$id_implode = implode("', '", $ids);
$second_query = "SELECT * FROM Table2 WHERE id in ('{$id_implode}');

edited Jun 16, 2011 at 20:15

answered Jun 9, 2011 at 21:54

Dan Soap

10.3k2 gold badges43 silver badges50 bronze badges

1 Comment

Paul DelRe Over a year ago

where id in must be surrounded by paraenthesis (). dev.mysql.com/doc/refman/5.1/en/expressions.html

Collectives™ on Stack Overflow

Use an array inside a query string

4 Answers 4

Comments

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Related