PHP MySQL Two queries

Question

I would like to Know how can I in PHP code, execute two mysql query (query_1 and query_2) but display only the results of query_2 for each result of query_1 like that :

query_1==> `SELECT tbl_name FROM table_ref `

query_2 ==> `SELECT id,name FROM (result of the first query)`

query_1 return the names of tables : table1, table2, table3, and with the query_2 I have to do this :

SELECT id,name FROM table1 and SELECT id,name FROM table2 ... as in a loop

Thanks in advance for your advice !

Hope tbl_name is not tablename :) Not getting crazy :)

chandresh_cool
– chandresh_cool

2013-04-12 10:09:34 +00:00
Commented Apr 12, 2013 at 10:09 — chandresh_cool
– chandresh_cool, Commented Apr 12, 2013 at 10:09

S.Visser · Accepted Answer · 2013-04-12 10:09:57Z

1

SELECT id, name FROM sometable WHERE name in (SELECT tbl_name FROM table_ref)

In this example there need to be a connection between 2 tables

answered Apr 12, 2013 at 10:09

S.Visser

4,7751 gold badge25 silver badges48 bronze badges

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

1 Comment

S. Walker Over a year ago

yeah but that's not quite what I need, because sometable comes from the second query which follow IN in your code

Angelin Nadar · Accepted Answer · 2013-04-12 10:43:53Z

0

On php side, you can deal with both the aray results as foll:

$array1 = array('tbl_name1' => '' ,'tbl_name2' => '');

$array2 = array('tbl_name1' => array('id' => 'id1'),
                'tbl_name2' => array('id' => 'id2'));

echo '<pre>';
print_r(array_intersect_key($array2, $array1));
echo '</pre>';

o/p:

Array
(
    [tbl_name1] => Array
        (
            [id] => id1
        )

    [tbl_name2] => Array
        (
            [id] => id2
        )

)

answered Apr 12, 2013 at 10:43

Angelin Nadar

9,39610 gold badges46 silver badges54 bronze badges

4 Comments

S. Walker Over a year ago

but how do i put the two queries together, especially that there is a lot of results

Angelin Nadar Over a year ago

array1 => result of query1, array2 => result of query2

S. Walker Over a year ago

I don't see where do you include query1 in query2, I need something like : SELECT id,name FROM (SELECT tbl_name FROM table_ref )

S. Walker Over a year ago

quer1 return the names of tables : table1, table2, table3, and with the query2 I have to do this : SELECT id,name FROM table1 and SELECT id,name FROM table2and ... as in a loop

Collectives™ on Stack Overflow

PHP MySQL Two queries

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related