how to get data from two tables from database and display in one html table

Question

I have 2 tables

1)students

students table looks like

stu_slno        stu_gr           stu_name
1               1                ABCDESDFDGFJ
2               3                KJJJHJILKJBJB
3               5                HAHAHAHAHKJHKJH
4               1                BBJHBAHJBHJBAJHK

2)groups

groups table looks like

sl_no         pg_groups

1             01-M.A HISTORY
3             03-M.A SOCIOLOGY
5             04-M.A ECONOMICS

i have inserted data into students with groups serial numbers when i am retrieving data from students i will get the groups serial number but what i want is to group names corresponding to the serial number

my code is of retrieving

<?PHP
$sql="SELECT * FROM students";
if ($us=$conn->query($sql)){;
if ($us->num_rows > 0) {
echo '<table border="2">';

    echo "<tr>";

        echo "<th>Slno</th>";

        echo "<th>Name</th>";

        echo "<th>Group</th>";

    echo "</tr>";
while($row = $us->fetch_assoc()) {
    echo "<tr>";

    echo "<td>" .$i++. "</td>";

    echo "<td>" .$row['stu_name']. "</td>";

    echo "<td>" .$row['stu_gr']. "</td>";   
    echo "</table>";
}

}
}

?>

use joins to get data from two tables.

Ravinder Reddy
– Ravinder Reddy

2016-04-06 15:04:50 +00:00
Commented Apr 6, 2016 at 15:04 — Ravinder Reddy
– Ravinder Reddy, Commented Apr 6, 2016 at 15:04

Adam Silenko · Accepted Answer · 2016-04-06 15:05:12Z

1

use join in query like this:

$sql="SELECT stu_slno, pg_groups, stu_name 
  FROM students s
  INNER JOIN groups g ON g.pg_groups = s.stu_gr";

answered Apr 6, 2016 at 15:05

Adam Silenko

3,1062 gold badges19 silver badges33 bronze badges

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

Comments

Ravinder Reddy · Accepted Answer · 2016-04-06 15:09:37Z

0

$sql = "SELECT s.*, g.pg_groups from students AS s LEFT JOIN groups as g ON g.sl_no = s.stu_gr";

TO display in the HTML table, use the below code

echo "<td>" .$row['pg_groups']. "</td>";

answered Apr 6, 2016 at 15:09

Ravinder Reddy

3,8791 gold badge16 silver badges24 bronze badges

Collectives™ on Stack Overflow

how to get data from two tables from database and display in one html table

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