Using Two Tables in PHP & MySQL to display one loop result

Question

Ok so a bit of a funny question here. I have two tables: -

LiveTable
ArchiveTable

The data is as follows: -

Table: LiveTable            Table: ArchiveTable

| ID | NAME      |          | ID | NAME      |
------------------          ------------------
|  1 | Test One  |          |  4 | Test Four |
------------------          ------------------
|  2 | Test Two  |          |  5 | Test Five |
------------------          ------------------
|  3 | Test Three|          |  6 | Test Six  |

What I want to do is merge them into one table for querying purposes only. Not as a Database Structure.

In essence when I do a PHP Loop I want the results to work like this: -

Merged Results

| ID | NAME      |
------------------
|  1 | Test One  |
------------------
|  2 | Test Two  |
------------------
|  3 | Test Three|
------------------
|  4 | Test Four |
------------------
|  5 | Test Five |
------------------
|  6 | Test Six  |

How would I go about doing this? Also is there a way of doing this with Doctrine?

print ist array than second array or use array_merge()

devpro
– devpro

2016-10-19 11:24:31 +00:00
Commented Oct 19, 2016 at 11:24 — devpro
– devpro, Commented Oct 19, 2016 at 11:24
Create view Using those two tables;

Mahesh Madushanka
– Mahesh Madushanka

2016-10-19 11:25:20 +00:00
Commented Oct 19, 2016 at 11:25 — Mahesh Madushanka
– Mahesh Madushanka, Commented Oct 19, 2016 at 11:25

Giorgos Betsos · Accepted Answer · 2016-10-19 11:25:55Z

1

You can use an SQL query with UNION:

SELECT ID, Name
FROM LiveTable            

UNION ALL

SELECT ID, Name
FROM ArchiveTable

Note: UNION ALL will retain duplicates. If you want to remove duplicate records, then use UNION.

answered Oct 19, 2016 at 11:25

Giorgos Betsos

72.3k10 gold badges69 silver badges103 bronze badges

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

Comments

Bart Friederichs · Accepted Answer · 2016-10-19 11:25:38Z

1

Yould use UNION:

SELECT id, name FROM tbl1
UNION ALL
SELECT id, name FROM tbl2

answered Oct 19, 2016 at 11:25

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

Comments

Mahesh Madushanka · Accepted Answer · 2016-10-19 11:27:06Z

1

Create DB view using above two tables

CREATE VIEW view_name AS SELECT 
  id, name FROM tbl1
UNION
  id, name FROM tbl2

Then you can query on your view

answered Oct 19, 2016 at 11:27

Mahesh Madushanka

3,0032 gold badges17 silver badges29 bronze badges

Comments

Hammad Friend · Accepted Answer · 2016-10-19 11:29:59Z

0

you can use the sql query multi table select

Select * from LiveTable,ArchiveTable

that's it

answered Oct 19, 2016 at 11:29

Hammad Friend

11 bronze badge

Collectives™ on Stack Overflow

Using Two Tables in PHP & MySQL to display one loop result

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related