ช่วยแก้ตงค้นหาหน่อยค่ะ ทำไม่มานค้นหาจากอีกตารางหนึ่งไม่ได้

<?php
include "chksession.php";  //check login 
include "header.php";
include "connect.php";
  
  
		$sql = "select * from suite";		
		if($_POST['type']  !="" && $_POST['keyword'] !=""){
		$type=$_POST['type'];
		$keyword=$_POST['keyword'];
		$sql .=" Where  $type like '%$keyword%' ";
		}
		$result  = mysql_query($sql);
		$nrowpage = mysql_num_rows($result);
		
		//แบ่งหน้า
		$list_page = 10; if (empty($page)) { $page=1; }
		$rt = $nrowpage%$list_page;
		if($rt != 0) { $totalpage = floor($nrowpage/$list_page)+1; } else { $totalpage = floor($nrowpage/$list_page); } 
		$goto = ($page-1)*$list_page;
		$sql .= " limit $goto, $list_page ";
		$rst=mysql_query($sql);	
		
		?>
<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
<tr>
            <td width="10%" height="23" align="left" valign="top" bgcolor="#FF99FF"><?php include "menu1.php";?></td>
<td valign="top" bgcolor="#FFFFFF"><table width="95%" border="0" align="center">
      <tr>
        <td height="744" align="left" valign="top"><p>
        
        <center>
        </center>
	</center>
	
	<table width="90%" border="0" align="center">
      <tr>
        <td align="center"><form id="form1" name="form1" method="post" action="<? $PHP_SELF ?>">
            <table width="78%" border="0">
              <tr>
                <td height="191" align="left"><fieldset>
                  <legend><strong>ค้นหาข้อมูลลูกค้า</strong></legend>
                  <p>&nbsp;</p>
                  <center>
                    <table width="100%" border="0">
                      <tr>
                        <td width="20%" align="left" nowrap="nowrap"><strong>ใส่คำค้นหา : </strong></td>
                        <td width="19%" align="left"><label>
                          <select name="type" id="type">
                            <option value="">---เลือก---</option>
                            <option value="type_name">ประเภทชุด</option>
                            <option value="suite_name">ชื่อชุด</option>
                            <option value="suite_size">ขนาดชุด</option>
                          </select>
                          </label>
                        </td>
                        <td width="20%" align="left" nowrap="nowrap"><strong>รายละเอียด :</strong></td>
                        <td width="29%" align="left"><input type="text" name="keyword" id="keyword" /></td>
                        <td width="12%" align="left"><input type="submit" name="button" id="button" value="ค้นหา" /></td>
                      </tr>
                    </table>
                    <p>&nbsp;</p>
                  </center>
                </fieldset></td>
              </tr>
            </table>
        </form></td>
      </tr>
    </table>
	<p>&nbsp;</p>
	<p align="center"><strong>จัดการข้อมูลชุด</strong><br>
	  </p>
	<center>
        
        <table width ="100%" border="0" align="center" cellpadding ="0" cellspacing ="1" bordercolor="#999999" bgcolor="#999999">
		<input type ="hidden"  name = "method"  value="<?php echo $method;?>"/>
		<tr bgcolor="#CC99FF">
		  <th align="center" bgcolor="#FF66CC">ลำดับ</th>
          <th align="center" bgcolor="#FF66CC">ประเภทชุด</th>
          <th align="center" bgcolor="#FF66CC">ชื่อชุด</th>
          <th align="center" bgcolor="#FF66CC">ขนาดชุด</th>
          <th align="center" bgcolor="#FF66CC">ราคาเช่าชุด</th>
		  <th align="center" bgcolor="#FF66CC">ราคาตัด</th>
          <th align="center" bgcolor="#FF66CC">จำนวนชุด</th>
		  <th align="center" bgcolor="#FF66CC">จัดการ	</th>
		</tr>

	
	<?php
	$color = "#BBF1FF";
			$result  = mysql_query($sql);
			while($row = mysql_fetch_array($result)) {
				 
				 $start++;
				 $type_id=$row['type_id'];
				 $suite_id=$row['suite_id'];
				 $suite_name=$row['suite_name'];
				 $suite_size=$row['suite_size'];
				 $suite_detail=$row['suite_detail'];
				 $suite_price_rent=$row['suite_price_rent'];
				 $suite_price_cut=$row['suite_price_cut'];
				 $suite_price_extra=$row['suite_price_extra'];
				 $suite_image=$row['suite_image'];
				 $suite_amount=$row['suite_amount'];
				
				$sql2="select * from suite_type where type_id='$type_id'";
							$result2 = mysql_query($sql2,$link);
							$row2 = mysql_fetch_array($result2);
							$type_name=$row2['type_name'];
				//ฟังก์ชันสลับสีแสดงผล
				if($color=="#FFCCFF"){
					$color="#FFFFFF";
					}else{
					$color="#FFCCFF";
				
					}
					/////////////////////////////////////////////////
					echo "<tr bgcolor=\"$color\" align=center>";
					echo "<td align='center'>$start</td>";
					echo "<td align='center'>$type_name</td>";
					echo "<td align='center'>$suite_name</td>";
					echo "<td align='center'>$suite_size</td>";
					echo "<td align='center'>$suite_price_rent</td>";
					echo "<td align='center'>$suite_price_cut</td>";
					echo "<td align='center'>$suite_amount</td>";
				
					
					
					echo "<td><a href=\"./frm_edit.php?suite_id=$suite_id\">แก้ไข</a> <a href=\"./delete_suite.php?method=delete&suite_id=$suite_id\" onClick=\"var x=confirm('ลบรายการนี้ทันที'); if (!x) return false;\">
					ลบ</a></td>";
					echo "</tr>";
			}
		?>
		
		<tr align="center" bgcolor="#CCCCCC" height="2">
			<td colspan="7" valign="top"></td>
		</tr>
		</table></center>
		<p align="center">
		  <?
   		for($i=1 ; $i<$page ; $i++) {
		print "<a href='$PHP_SELF?type=$type&keyword=$keyword&page=$i'>$i</a> "; }
		print "<font size='3' color='#000000'><b>[$page]</b></font> ";
		for($i=$page+1 ; $i<=$totalpage ; $i++) {
		print "<a href='$PHP_SELF?type=$type&keyword=$keyword&page=$i'>$i</a> "; }
	?>
		</p>
    <p align="center">ทั้งหมด <strong>
    <?=$nrowpage?>
    </strong> รายการ <br>
                </p>
		<center></td>
      </tr>
    </table></td>
  </tr>
</table>
</td>
</tr>

<? include "footer.php"; ?>