need help w/radio button link

12Strings

I'm trying to create a mysgli dropdown and link to a url in the selected row via radio
button. This is my pastime. I had the dropdown working earlier but screwed it up trying to link a field. I wonder where all the echos come from. I've included a screen shot. Any pointers?

<!DOCTYPE html><html>

<title>autopay Report</title>

<STYLE TYPE="text/css">
<!--
TD { font-family: Arial; font-size: 8pt;}
--->
</STYLE>

<STYLE TYPE="text/css">
<!DOCTYPE html><html>
<head>

<style>
table { border-collapse: collapse; width: 100%; }
th, td { padding: 8px; text-align: left; border-bottom: 1px solid #ddd; }
tr:hover{background-color:#ccffff}
</style>

</head>
<body><center>

 <form id="emailform" name="emailform" action="" method="post" accept-charset="UTF-8">
   <table border=1 cellpadding=2 cellspacing=2 bgcolor="#D4FFAA">
 <tr>
<th>id</th>
    <th>target</th><th>username</th><th>password</th><th>purpose</th>
    <th>emailused</th><th>lastused</th><th>visit-count</th><th>time-visited</th><th>saved</th>
 </tr>

<?php
$connect=mysql_connect("localhost", "root", "cookie") or die("error");
mysql_select_db("homedb", $connect);
$sql="SELECT * from emailtbl";
$result=mysql_query($sql, $connect);
while($res=mysql_fetch_assoc($result))
{
echo "<tr>"; 
echo "<td>"; echo '<input type="radio" name="index" >'; echo "</td>"; 
echo "<td>"; echo $res['target'];    echo "</td>";
echo "<td>"; echo $res['username']; echo "</td>"; 
echo "<td>"; echo $res['password'];       echo "</td>"; 
echo "<td>"; echo $res['purpose'];   echo "</td>"; 
echo "<td>"; echo $res['emailused'];  echo "</td>";
echo "<td>"; echo $res['lastused']; echo "</td>"; 
echo "<td>"; echo $res['visit-count']; echo "</td>"; 
echo "<td>"; echo $res['time-visited']; echo "</td>"; 
echo "<td>"; echo $res['saved']; echo "</td>"; 
echo "</tr>";
}
?>

 </table> </form></body></html>

cluelessPHP

Well that isn't sqli so that is one of your main problems, this is an example you will have to place your database name where it says "YOUR DATABASE HERE"

This is a great tool to learn from (before laserlight points to it :p )
http://php.net/manual/en/manual.php

Also indentation is a habbit you should get into it really helps you read your code.

<!DOCTYPE html><html>

<title>autopay Report</title>

<STYLE TYPE="text/css">
<!--
TD { font-family: Arial; font-size: 8pt;}
--->
</STYLE>

<STYLE TYPE="text/css">
<!DOCTYPE html><html>
<head>

<style>
table { border-collapse: collapse; width: 100%; }
th, td { padding: 8px; text-align: left; border-bottom: 1px solid #ddd; }
tr:hover{background-color:#ccffff}
</style>

</head>
<body><center>

 <form id="emailform" name="emailform" action="" method="post" accept-charset="UTF-8">
   <table border=1 cellpadding=2 cellspacing=2 bgcolor="#D4FFAA">
 <tr>
<th>id</th>
    <th>target</th><th>username</th><th>password</th><th>purpose</th>
    <th>emailused</th><th>lastused</th><th>visit-count</th><th>time-visited</th><th>saved</th>
 </tr>

 <?php 
$connect=mysqli_connect("localhost","root","","YOUR DATABASE HERE");
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
	$sql = "SELECT * FROM emailtbl";
	$result = mysqli_query($connect, $sql);
	if($result == false) {
		die("Query failed: ".mysqli_error().PHP_EOL.$sql);
	}
while($res = mysqli_fetch_assoc($result));
{ 
	echo "<tr>";  

	echo "<td>"; echo '<input type="radio" name="index" >'; echo "</td>";  

	echo "<td>"; echo $res['target'];    echo "</td>"; 
	echo "<td>"; echo $res['username']; echo "</td>";  

	echo "<td>"; echo $res['password'];       echo "</td>";  

	echo "<td>"; echo $res['purpose'];   echo "</td>";  

	echo "<td>"; echo $res['emailused'];  echo "</td>"; 
	echo "<td>"; echo $res['lastused']; echo "</td>";  

	echo "<td>"; echo $res['visit-count']; echo "</td>";  

	echo "<td>"; echo $res['time-visited']; echo "</td>";  

	echo "<td>"; echo $res['saved']; echo "</td>";  

	echo "</tr>"; 
} 

mysqli_close($connect);
?>

 </table> </form></body></html>