PHP show data with select query

<?php
include "connection.php"

?>
<html><head>
<title></title>
</head>
<body>

<table border='1'  cellpadding='10'>
<tr><th>Name</th><th>Email</th><th>Address</th><th>Phone</th><th>Joining Date</th><th>Performance</th><th>ID</th></tr>
<?php

$query=mysql_query("select * from employee_record order by joining_date");
while($result=mysql_fetch_array($query))
{
?>

<tr><td><?php echo $result['name'];?></td><td><?php echo $result['email'];?></td><td><?php echo $result['address'];?></td><?php echo $result['joiningdate'];?><td><?php echo $result['performance'];?></td><td><?php echo $result['id'];?></td></tr>
<?php  }?>
</table>








<ul>
<?php

$query=mysql_query("select * from employee_record order by joining_date");
while($result=mysql_fetch_array($query))
{
?>
<li><?php echo $result['name'];?></li>
<?php  }?>
<li><?php echo $result['name'];?></li>
<li><?php echo $result['name'];?></li>
<li><?php echo $result['name'];?></li>
<li><?php echo $result['name'];?></li>

</ul>



<select name="" id="">

<?php

$query=mysql_query("select * from employee_record order by joining_date");
while($result=mysql_fetch_array($query))
{
?>

<option value="<?php echo $result['email'];?>"><?php echo $result['email'];?>
</option>

<?php  }  ?>

</select>



<?php

$query=mysql_query("select * from employee_record order by joining_date");
while($result=mysql_fetch_array($query))
{
?>
<input type="radio" name="s_name" value="<?php echo $result['name']; ?>"/><?php echo $result['name']; ?>
<?php}?>





<?php

$query=mysql_query("select * from employee_record where name='eena' order by joining_date");
while($result=mysql_fetch_array($query))
{
?>
<input type="text"  value="<?php echo $result['name']; ?>"/><?php echo $result['name']; ?>
<?php}?>

</body>

</html>