EDITAR Y BORRAR DATOS MYSQL-PHP

EDITAR DATOS
<?PHP
$conexion=mysql_connect("localhost","CONEXIONBDD","ADMIN");
if(!$conexion){
die('no se establecio la conexion'.mysql_error());
}
else
{
echo("Conexion Satisfactoria");
echo "<br>";
}
mysql_select_db("BDDAGENDA",$conexion);
echo "<center>";
$sql=mysql_query("select * from agenda");

echo "<table bgcolor='yellow' BORDER=0 cellspacing=0 text='orange'>";
echo "<tr><td WIDTH=7%>ID</td><td WIDTH=25%>Nombre</td><td WIDTH=25%>Apellido</td><td WIDTH=25%>Direccion</td><td WIDTH=20%>Telefono </td><td>Accion</td></tr>";
echo "</table>";
echo "<form ACTION='editado.php' method='POST'>";
$con=0;
while($fila=mysql_fetch_array($sql))
{

/*$var=mysql_num_rows($sql);*/

$con=$con+1;
echo "<table BORDER=1 cellspacing=0 bgcolor='red' text='orange'>";
echo "<tr><td WIDTH=5%>$fila[IDAGENDA]</td>";
echo "<td WIDTH=26%>".$fila['Nombre']."</td>";
echo "<td WIDTH=25%>".$fila['Apellido']."</td>";
echo "<td WIDTH=25%>".$fila['Direccion']."</td>";
echo "<td WIDTH=19%>".$fila['Telefono']."</td>";
ECHO "<TD><A HREF='EDITADO.PHP?cod=$fila[IDAGENDA]'>EDITAR</A></TD>";
echo "</tr>";

echo "</table>";
}

?>
-------------------------------------------------------------------------------------------------

<?PHP
$cod=$_GET['cod'];
$conexion=mysql_connect("localhost","CONEXIONBDD","ADMIN");
if(!$conexion){
die('no se establecio la conexion'.mysql_error());
}
else
{
echo("Conexion Satisfactoria");
}
ECHO "<h1>EDITAR</H1>";
echo "<FORM ACTION='' method='POST'>";
mysql_select_db("BDDAGENDA",$conexion);
$sql=mysql_query("select * from agenda
WHERE IDAGENDA=$cod");
$fila=mysql_fetch_array($sql);
echo "<input type='text' name='cod' value='$fila[IDAGENDA]'>";
ECHO "</BR>";
echo "<input type='text' name='nom' value='$fila[Nombre]'>";
ECHO "</BR>";
echo "<input type='text' name='ape' value='$fila[Apellido]'>";
ECHO "</BR>";
echo "<input type='text' name='dir' value='$fila[Direccion]'>";
ECHO "</BR>";
echo "<input type='SUBMIT' NAME='env' value='GUARDAR'>";
echo "</form>";
mysql_select_db("BDDAGENDA",$conexion);

$cod=$_POST['cod'];
$nom=$_POST['nom'];
$ape=$_POST['ape'];
$dir=$_POST['dir'];
if(mysql_query("UPDATE agenda set Nombre='$nom',Apellido='$ape',Direccion='$dir'
where IDAGENDA=$cod",$conexion))
{echo "<br> Insertado correctamente";}
else{
echo "<br> se produjo un esrror".mysql_error();
}
}
?>


ELIMINAR DATOS
<?PHP
echo "<br>";
ECHO "<h1>ELIMINAR</H1>";
ECHO "<BR>";

$conexion=mysql_connect("localhost","CONEXIONBDD","ADMIN");
if(!$conexion){
die('no se establecio la conexion'.mysql_error());
}
else
{
echo("Conexion Satisfactoria");
echo "<br>";
}
mysql_select_db("BDDAGENDA",$conexion);
echo "<center>";
$sql=mysql_query("select * from agenda");

echo "<table bgcolor='yellow' BORDER=0 cellspacing=0 text='orange'>";
echo "<tr><td WIDTH=7%>ID</td><td WIDTH=25%>Nombre</td><td WIDTH=25%>Apellido</td><td WIDTH=25%>Direccion</td><td WIDTH=20%>Telefono </td><td>Accion</td></tr>";
echo "</table>";
while($fila=mysql_fetch_array($sql))
{
echo "<table BORDER=1 cellspacing=0 bgcolor='red' text='orange'>";
echo "<tr><td WIDTH=5%>$fila[IDAGENDA]</td>";
echo "<td WIDTH=26%>".$fila['Nombre']."</td>";
echo "<td WIDTH=25%>".$fila['Apellido']."</td>";
echo "<td WIDTH=25%>".$fila['Direccion']."</td>";
echo "<td WIDTH=19%>".$fila['Telefono']."</td>";
ECHO "<TD><A HREF='ELIMINADO.PHP?cod=$fila[IDAGENDA]'>ELIMINAR</A></TD>";
echo "</tr>";

echo "</table>";
}


?>
--------------------------------------------------------------------------------------------







<?PHP
$cod=$_GET['cod'];
$conexion=mysql_connect("localhost","CONEXIONBDD","ADMIN");
if(!$conexion){
die('no se establecio la conexion'.mysql_error());
}
else
{
echo("Conexion Satisfactoria");
}
ECHO "<h1>ELIMINAR</H1>";
mysql_select_db("BDDAGENDA",$conexion);
if(mysql_query("delete from agenda where IDAGENDA=$cod",$conexion))
{echo "<br> Eliminado correctamente";}
else{
echo "<br> se produjo un esrror".mysql_error();
}

?>