This Example illustrates how to use right join clause in the sql query. The right join return all rows from the right table, even if there are no matches in the left table.

PHP SQL Right Join

 This Example illustrates how to use right join clause in the sql query. The right join return all rows from the right table, even if there are no matches in the left table.

In this example right join is used to join the two table data according to the "message" table id. The fetched data displays in the table format on the browser. We use "emp" table and "message" table and find the emp.name from emp table and find the message.messages from message table where emp.emp_id and message.emp_id both are equal. The fetched result display on the browser as below and the complete source code is available below for download or copy the code as per your need.

The "RIGHT JOIN" keyword is used for join the table data.

Table: emp

Table: message

 

Source Code of rightJoin.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     RIGHT 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

Related Tags for PHP SQL Right Join: