$con=mysql_connect("localhost","root","arun123");
$db=mysql_select_db("address",$con);
$sql="select * from personal order by name";
$res=mysql_query($sql,$con);
echo"
Indian Institute of Spices Research: Address
BookType the Name and Press Enter Key
| Name |
Present Address |
Permanent Address |
Phone No. |
";
while($row=mysql_fetch_array($res)){
$name=$row["name"];
$des=$row["des"];
$pre=$row["pre"];
$per=$row["per"];
$ph=$row["ph"];
$email1=$row["email1"];
$email2=$row["email2"];
echo"$name $des $email1 $email2 | $pre | $per | $ph |
";
}
echo"
";
?>