Mostrando campos con SELECT

[dachi]

#####Esta es la 2 parte#####
[CODE] <table width=650 border="1" bordercolor="#000000" cellpadding="2" cellspacing="0"><tr><th bgcolor=#D3DCE3 class=cuerpo>Dia del alta <a href="admin.php?a=view&ordenar=1"&gt ;<img src="asc_order.gif" border=0 width=7 height=7 alt=\"Ascendente\"></a><a href="admin.php?a=view&ordenar=2"&gt ;<img src="desc_order.gif" border=0 width=7 height=7 alt=\"Descendente\"></a></th>
<th bgcolor=#D3DCE3 class=cuerpo>Número de Id<a href="admin.php?a=view&ordenar=3"&gt ;<img src="asc_order.gif" border=0 width=7 height=7 alt=\"Ascendente\"></a><a href="admin.php?a=view&ordenar=4"&gt ;<img src="desc_order.gif" border=0 width=7 height=7 alt=\"Descendente\"></a></th>
<th bgcolor=#D3DCE3 class=cuerpo>Nombre<a href="admin.php?a=view&ordenar=5"&gt ;<img src="asc_order.gif" border=0 width=7 height=7 alt=\"Ascendente\"></a><a href="admin.php?a=view&ordenar=6"&gt ;<img src="desc_order.gif" border=0 width=7 height=7 alt=\"Descendente\"></a></th>
<th bgcolor=#D3DCE3 class=cuerpo>Emails<a href="admin.php?a=view&ordenar=7"&gt ;<img src="asc_order.gif" border=0 width=7 height=7 alt=\"Ascendente\"></a><a href="admin.php?a=view&ordenar=8"&gt ;<img src="desc_order.gif" border=0 width=7 height=7 alt=\"Descendente\"><a/></th>
<th bgcolor=#D3DCE3 class=cuerpo>Borrar</th>
</tr>
<?
$i=0;
while($subscriber = mysql_fetch_array($result)) {
$i++;
echo " <form action=\"admin.php\" method=\"post\"><tr>\n";
echo " <td class=cuerpo>".$fecha = $subscriber['fecha'];."</td>\n";
echo " <td class=cuerpo>".$id = $subscriber['id'];."</td>\n";
echo " <td class=cuerpo>".$name = $subscriber['name'];."</td>\n";
echo " <td class=cuerpo>".$email = $subscriber['email'];."</td>\n";
echo " <td>\n";
echo " <input type=\"hidden\" name=\"a\" value=\"delete\">\n";
echo " <input type=\"hidden\" name=\"email\" value=\"$email\">\n";
echo " <input type=\"submit\" value=\"Borrar\" class=a></td>\n";
echo " </tr></form>\n";
}
$result = mysql_query($query);
echo "</table>\n";
?>

Código:

Garacias