<?php
  // conn.php
  $host = "localhost";
  $user = "root";
  $pswd = "";
  $conn = mysql_connect($host,$user,$pswd);
  $db = "employee";
  $objDB = mysql_select_db($db);
  if($conn)
  {
    echo "MySQL Connected";
  }
  else
  {
    echo "MySQL Connect Failed : Error : ".mysql_error();
  }
?>

//list.php
<?php
  include("conn.php");
  $sql = " SELECT * FROM emp,dep WHERE emp.dep_id = dep.dep_id ";  
  $result = mysql_query($sql) or die (mysql_error());
?>
<TABLE>
<? while($data = mysql_fetch_array($result)) {?>
	<TR>
    <TD><?echo $data["emp_id"]?></TD>
    <TD><?echo $data["emp_name"]?></TD>
    <TD><?echo $data["dep_id"]?></TD>
    <TD><?echo $data["dep_name"]?></TD>
	</TR>
<? } ?>
</TABLE>