MySQL PHP Search

mysql> CREATE TABLE MyTable (
    ->              Empid int(10),
    ->              Empname varchar(60)
    ->              Salary int(90)
    ->            );
Query OK, 0 rows affected (0.13 sec)

mysql>   insert into MyTable values(01,'Girish','20000');
Query OK, 1 row affected (0.02 sec)

mysql>   insert into MyTable values(10,'Komal','20000');
Query OK, 1 row affected (0.01 sec)

mysql>   insert into MyTable values(02,'Amit','21000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(03,'C','22000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(04,'V','23000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(05,'B','24000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(06,'E','25000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(07,'Q','26000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(08,'W','27000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(09,'AS','28000');
Query OK, 1 row affected (0.00 sec)`

mysql> select * from mytable;
+-------+---------+--------+
| Empid | Empname | Salary |
+-------+---------+--------+
| 1     | Girish  |  20000 |
| 10    | Komal   |  20000 |
| 2     | Amit    |  21000 |
| 3     | C       |  22000 |
| 4     | V       |  23000 |
| 5     | B       |  24000 |
| 6     | E       |  25000 |
| 7     | Q       |  26000 |
| 8     | W       |  27000 |
| 9     | AS      |  28000 |
+-------+---------+--------+
10 rows in set (0.00 sec)

<?php

$database="girish";
$user="root";
$password="root";
$host="192.168.10.126";

$link= mysql_connect($host,$user,$password) or die("Could not connect: ".mysql_error());

mysql_select_db($database,$link) or die("Error in selecting the database:".mysql_error());

$sql="select * from mytable where Empname=\"girish\"";

mysql_query($sql,$link) or exit("Sql Error".mysql_error());

$sql_result=mysql_query($sql,$link) or exit("Sql Error".mysql_error());

$sql_num=mysql_num_rows($sql_result);
echo "<table border=\"1\" bgcolor=\"#CCCCFF\" >";
echo "<tr><td><b>Empid</b></td><td><b>Empname</b></td><td><b>Salary</b></td>" ;
while($sql_row=mysql_fetch_array($sql_result))
{
	$Empid=$sql_row["Empid"];
	$Empname=$sql_row["Empname"];
	$Salary=$sql_row["Salary"];

	echo "<tr>";
	echo "<td>".$Empid."</td>";
	echo "<td>".$Empname."</td>";
	echo "<td>".$Salary."</td>";
	echo "</tr>";
}	
	echo "</table>";
?>