using arrays to query with SELECT with PHP

Question

I'm querying a table that returns id's and I'd like to use these id's within an array to perform another query.

I have the two queries working independently of each other by hard coding the id's into the second query just to be sure that it functions as expected, which it does.

$query = "SELECT item_id FROM items"; 

$query = "SELECT * FROM results WHERE results_item_id in (1,2,3,4)";

I'd like the return of the second query to include data for all of the id's returned to me from the first query.

Arulkumar · Accepted Answer · 2019-05-27 17:44:21Z

2

Instead of sub query, you can do it by JOIN matching ON item_id = results_item_id

$query = "SELECT R.* FROM results R JOIN items I ON I.item_id = R.results_item_id";

answered May 27, 2019 at 17:44

Arulkumar

13.3k14 gold badges51 silver badges76 bronze badges

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

Comments

Arulkumar · Accepted Answer · 2019-05-27 17:47:58Z

1

Just put the query inside the IN, and add distinct so each item_id you only get in once:

$query = "SELECT * FROM results WHERE results_item_id in (SELECT distinct item_id FROM items)";

edited May 27, 2019 at 17:47

Arulkumar

13.3k14 gold badges51 silver badges76 bronze badges

answered May 27, 2019 at 17:32

nacho

5,3772 gold badges28 silver badges35 bronze badges

Collectives™ on Stack Overflow

using arrays to query with SELECT with PHP

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