PHP/sql, join two tables and get an array

Question

I have two sql tables :

table_A : 
ID     VALUE
1      a
2      b
3      c
4      d

table_B : 
ID     VALUE
2      oA
4      oB
1      oC
3      oD

I'm looking for an sql query for get this php array :

$myarray = (
    "a" => "oC",
    "b" => "oA",
    "c" => "oD",
    "d" => "oB",
);

Is it possible to get this result with one query ? Can you help me ?

Yes it's possible.

Mawia HL
– Mawia HL

2016-12-12 15:45:10 +00:00
Commented Dec 12, 2016 at 15:45 — Mawia HL
– Mawia HL, Commented Dec 12, 2016 at 15:45

Federkun · Accepted Answer · 2016-12-12 15:48:53Z

1

You can do that with an INNER JOIN. Here's a PDO example:

$sql = 'SELECT a.VALUE AS aVal, b.VALUE AS bVal FROM table_A a INNER JOIN table_B b ON a.id = b.id';
foreach ($pdo->query($sql) as $row) {
    $result[$row['aVal']] = $row['bVal'];
}

answered Dec 12, 2016 at 15:48

Federkun

37.2k8 gold badges82 silver badges93 bronze badges

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

Comments

Charles Bretana · Accepted Answer · 2016-12-12 15:53:56Z

1

or...

Select '"' + a.Value + '" => "' + b.Value + '",'
From table_A a join table_B b
   on b.Id = a.Id

answered Dec 12, 2016 at 15:53

Charles Bretana

147k24 gold badges158 silver badges219 bronze badges

Collectives™ on Stack Overflow

PHP/sql, join two tables and get an 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