PHP MySQL Query Use RIGHT OUTER JOIN
From w3cyberlearnings
Contents |
PHP MySQL RIGHT OUTER JOIN
RIGHT JOIN uses to join two tables based on the right table. This JOIN will return NULL for the left table when the join condition is not true.
Syntax
SELECT em.id as employee_id, em.name, em.grade, sal.salary, sal.id as salary_id FROM employee em RIGHT OUTER JOIN employee_salary sal ON em.id = sal.employee_id AND em.grade='a'
Example 1
<?php
define('HOST', 'localhost');
define('USER', 'root');
define('PASS', 'yeething');
define('DBNAME', 'woowood');
$connection = mysql_connect(HOST, USER, PASS)
or die("can not connect to the server!<br/>");
$rdb = mysql_select_db(DBNAME)
or die("The " . DBNAME . "database could not be selected");
$grade = 'a';
$sel_query = "
SELECT
em.id as employee_id,
em.name,
em.grade,
sal.salary,
sal.id as salary_id
FROM
employee em
RIGHT OUTER JOIN
employee_salary sal
ON em.id = sal.employee_id AND
em.grade='{$grade}'";
$result = mysql_query($sel_query, $connection) or die(mysql_error($connection));
echo '<table border="1">';
echo '<tr><th>employee id</th>
<th>Name</th>
<th>Grade</th>
<th>salary</th>
<th>salary id</th></tr>';
while ($row = mysql_fetch_assoc($result)) {
echo '<tr>';
foreach ($row as $value) {
echo '<td>' . $value . '</td>';
}
echo "</tr>";
}
echo '</table>';
mysql_close($connection);
?>
Output
