เช็ดสถานะการจองคับ ช่วยผมที งง มาหลายวันแล้ว ช่วยด้วย

$strSQL1 = "select * from book a inner join book_borrow on book.call_number = book_borrow.call_number";
$query = mysql_query($strSQL1) ;
   while($row=mysql_fetch_array($query)){
        if($row['call_number'] !=""){
        echo $row['call_number']."Yes";
        } else {
        echo  $row['call_number']."No";
        }
  }
}

<?
if($_GET["txtKeyword"] != "")
	{
	$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
	$objDB = mysql_select_db("admin");
	// Search By Name or Email
	mysql_query("SET NAMES UTF8");
	$strSQL = "SELECT * FROM book WHERE (call_number LIKE '%".$_GET["txtKeyword"]."%' or name_book LIKE '%".$_GET["txtKeyword"]."%'
	or name_author LIKE '%".$_GET["txtKeyword"]."%')";
	
	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
	$Num_Rows = mysql_num_rows($objQuery);


	$Per_Page = 10;   // Per Page

	$Page = $_GET["Page"];
	if(!$_GET["Page"])
	{
		$Page=1;
	}

	$Prev_Page = $Page-1;
	$Next_Page = $Page+1;

	$Page_Start = (($Per_Page*$Page)-$Per_Page);
	if($Num_Rows<=$Per_Page)
	{
		$Num_Pages =1;
	}
	else if(($Num_Rows % $Per_Page)==0)
	{
		$Num_Pages =($Num_Rows/$Per_Page) ;
	}
	else
	{
		$Num_Pages =($Num_Rows/$Per_Page)+1;
		$Num_Pages = (int)$Num_Pages;
	}


	
	$objQuery  = mysql_query($strSQL);


	?>
	<table width="600" border="1">
	  <tr>
		<th width="91"> <div align="center">call_number </div></th>
		<th width="98"> <div align="center">name_book </div></th>
		<th width="198"> <div align="center">name_author </div></th>

		<th width="198"> <div align="center">สถานะ </div></th>
		</tr>
	<?
	while($objResult = mysql_fetch_array($objQuery))
	{
	?>

	  <tr>
		<td><div align="center"><?=$objResult["call_number"];?></div></td>
		<td><?=$objResult["name_book"];?></td>
		<td><div align="center"><?=$objResult["name_author"];?></div></td>
		<td><div align="center">
		<?
		

	  //ยังไม่สมบูรณ์ตั้งฟังชั้น
//$strSQL1 = "SELECT * FROM book LEFT JOIN book_borrow ON book.call_number = book_borrow.call_number where book.call_number != book_borrow.call_number   ";
	$strSQL1 = "select * from book a inner join book_borrow on book.call_number = book_borrow.call_number";
	$query = mysql_query($strSQL1) ;
	while($row=mysql_fetch_array($query))
		{

	  				if ($row['book_borrow.call_number'] != "" )
							{
							
								echo $row['call_number']."Yes";
						}
						
						else 
								 echo  $row['call_number']."No";
						}
	
							//echo "<a href=oo.php target=_blank>yes</a>" ;

       //$query	= mysql_query($strSQL1) ;
	  //$rows = mysql_num_rows($query);
	  ?>
	  </div></td>
	  </tr>



	<?
	}
	?>
	</table>
	<br>
	Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
	<?
	if($Prev_Page)
	{
		echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'><< Back</a> ";
	}

	for($i=1; $i<=$Num_Pages; $i++){
		if($i != $Page)
		{
			echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
		}
		else
		{
			echo "<b> $i </b>";
		}
	}
	if($Page!=$Num_Pages)
	{
		echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next>></a> ";
	}
	
	mysql_close($objConnect);
	}?>