PHP SQL Inner Join
This Example illustrates how to use the inner join clause in the sql
query.
JOIN is used to query data from two or more tables. The inner join
is used in the case of need to return rows when there is at least one match in both
tables. This is the good example to understand inner join clause because in this
example we use a join clause between only two table. We use "emp" table and "message"
table and find the name from emp table and messages from the message table where
emp_id in the emp table and emp_id in the message table are equal. The fetched result
is displayed on the browser as below. The complete source code is available below
for download or copy the code as per your need.
Table: emp
Table: message
Source Code of innerJoin.php
<?php
$con = mysql_connect("localhost","root","root");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
$result = mysql_query("SELECT emp.name, message.messages
FROM emp INNER JOIN message ON emp.emp_id = message.emp_id");
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Message</th>
</tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['messages'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
|
Output:
Download Source Code
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
