สอบถามการค้นหาข้อมูลจาก ฐานข้อมูล ให้แสดงเฉพาะข้อมูลบุคคลที่เราค้นหาครับ

<?
$hostname = "localhost";
$user = "nbrregiste_user"; 
$password = "5504015933"; 
$dbname = "nbrregiste_nbrwatpondb"; 
$tblname = "students"; 
$field_search = "student_studentid";
mysql_connect($hostname, $user, $password) or die("ติดต่อฐานข้อมูลไม่ได้");
mysql_select_db($dbname) or die("เลือกฐานข้อมูลไม่ได้");
$sql = "select * from $tblname where student_studentid='".$search."';
$dbquery = mysql_db_query($dbname, $sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result = mysql_fetch_array($dbquery);
$id = $result[student_idcard];
$name = $result[student_name];
$grade = $result[student_oldschool];
echo "รหัส : $id - ชื่อ : $name - เกรด : $grade <BR>"; //แสดงข้อมูล 
$i++;
}
mysql_close();
?>

<?
$hostname = "localhost";
$user = "nbrregiste_user"; 
$password = "5504015933"; 
$dbname = "nbrregiste_nbrwatpondb"; 
$tblname = "students"; 
$field_search = "student_studentid";
mysql_connect($hostname, $user, $password) or die("µÔ´µèÍ°Ò¹¢éÍÁÙÅäÁèä´é");
mysql_select_db($dbname) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é");
$sql = "select * from students where student_idcard like '%$search%'";	//¤ÓÊÑè§ Sql ·Õèãªé;
$dbquery = mysql_db_query($dbname, $sql);
$num_rows = mysql_num_rows($dbquery);
$i=0;
while ($i < $num_rows)
{
$result = mysql_fetch_array($dbquery);
$id = $result[student_idcard];
$name = $result[student_name];
$grade = $result[student_oldschool];
echo "ÃËÑÊ : $id - ª×èÍ : $name - à¡Ã´ : $grade <BR>"; //áÊ´§¢éÍÁÙÅ 
$i++;
}
mysql_close();
?>