เรื่องโปรเจคค่ะ รบกวนพี่ๆ ทุกท่านนะค่ะคือว่าอยากจะทำการค้นหาข้อมูลนักเรียนค่ะ

<?
$host = "localhost";
$user = "root";
$password = "1234";
$dbname = "namebook";

 $link=mysql_connect($host, $user, $password);
 mysql_query("Set names tis620");
 mysql_select_db("$dbname");
   if($type==1)
   {
	$sql=("SELECT * FROM `book` WHERE `title` LIKE '%$search%' ");
   }
      if($type==2)
   {
	$sql=("SELECT * FROM `book` WHERE `year` LIKE '%$search%' ");
   }
      elseif($type==3)
   {
	$sql=("SELECT * FROM `book` WHERE `amount` LIKE '%$search%' ");
   }
  
   $result=mysql_query($sql, $link);
   echo"<table border align=center width=100%>";
   echo"<tr align=center bgcolor=#4697D2>";
   echo"<td><font color=#FFFFFF><B>ลำดับที่</B></font>";
   echo"<td><font color=#FFFFFF><B>ชื่อหนังสือ</B></font>";
   echo"<td><font color=#FFFFFF><B>ปี</B></font>";
   echo"<td><font color=#FFFFFF><B>จำนวน</B></font>";
   echo"</tr>";
   $i=1;
   while ($arr=mysql_fetch_array($result))
   {

	echo"<tr>";
	echo"<td align=center><font size=2>".$i."</td>";
	//echo"<td><font size=2>".$arr['id']."</td>";
	echo"<td><font size=2><a href=\"show.php?id=".$arr['id']."\">".$arr['title']."</a></td>"; 
	echo"<td><center><font size=2>".$arr['year']."</td>";
	echo"<td><center><font size=2>".$arr['amount']."</td>";
	echo"</tr>";
	$i++;

   }
   echo"</table>";
?>