问链接数据库中的两个表

EN

<?php
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = "";
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);
    if(! $conn )
    {
       die('Could not connect: ' . mysql_error());
    }
     $sql = 'SELECT a.`Issued to`, b.Name, b.DOB, b.Discipline, b.Designation, b.PlaceOfPosting, b.PhoneNo, b.Email
        FROM db a, details b
        WHERE a.`Issued to` = b.`Issued to`';

    mysql_select_db('testdb');
    $retval = mysql_query( $sql, $conn );
    if(! $retval )
    {
      die('Could not get data: ' . mysql_error());
    }
    while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
    {
         echo "Name:{$row['Name']}  <br> ".
         "Date Of Birth:{$row['DOB']}  <br> ".
         "Discipline:{$row['Discipline']}  <br> ".
         "Designation:{$row['Designation']}  <br> ".
         "Place of Posting:{$row['PlaceOfPosting']}  <br> ".
         "Phone: {$row['PhoneNo']} <br> ".
         "Email Id: {$row['Email']} <br> ".
         "--------------------------------<br>";
    } 
    mysql_close($conn);
   ?>