Display two tables data in single page

Question

I have two tables called users and vm_tables. Now I am displaying data from users as below.

 $sel_query="Select * from users where account_id=".$_SESSION['admin_id'];

<td align="left"><?php echo $row["username"]; ?></td>
<td align="left"><?php echo $row["email_address"]; ?></td>

I would like to display data from vm_details also in same table.

Can anyone help me how to merge two tables data please.

refer [here](http://stackoverflow.com/questions/12890071/select-from-multiple-tables-mysql) — Carl Binalla, Mar 06 '17 at 10:00
Use [join](https://dev.mysql.com/doc/refman/5.7/en/join.html) — Rafiqul Islam, Mar 06 '17 at 10:06
@Keerthi let us show your tables structure if there is any common field between both, so use join — lazyCoder, Mar 06 '17 at 10:14

score 0 · Answer 1 · answered Mar 06 '17 at 10:05

0

One way is to fetch data from 2 tables in 2 separate arrays and merge the arrays into one using array_merge or array_combine functions

answered Mar 06 '17 at 10:05

monica kalra

1
1

1

what if both the table has same column name ? array merge will override the values – lazyCoder Mar 06 '17 at 10:17

score 0 · Answer 2 · answered Mar 06 '17 at 10:17

0

you can create single table using JOIN and get both table data together (for this you have to have foreign key with ur second table) or use 2 sql_query arrays n display in one table both are possible.

answered Mar 06 '17 at 10:17

Sampath Munaweera

119
2
13

score 0 · Answer 3 · answered Mar 06 '17 at 10:18

0

you could use join

Select * from users u
LEFT JOIN vm_details v ON v.common_field=u.common_field
where u.account_id=".$_SESSION['admin_id']

whereas common_field is identical column on both table.

answered Mar 06 '17 at 10:18

Tigris

86
1
10

how do you know that both the table has a common field, did he say about that? – lazyCoder Mar 06 '17 at 10:21
what is the necessary to join two un related tables? – Tigris Mar 06 '17 at 10:22
that is not necessary what if he wants to first show the 1st table data and then below 2nd table data ? – lazyCoder Mar 06 '17 at 10:25
if her table has two common columns can use this solution... is it ok now @BunkerBoy r u happy :D – Tigris Mar 06 '17 at 10:28
It is all up to her @ Pattatharasu Nataraj do be serious :) (y) – lazyCoder Mar 06 '17 at 10:31
exactly @BunkerBoy ;) :) – Tigris Mar 06 '17 at 10:35

Display two tables data in single page

3 Answers3