selectmenu("SELECT * FROM types","<option value=\"{id}\" {selectedtype}>{nombre}</option>\n");
?>
</select>
</td>
<td id="s2">EMAIL:</td>
<td>
<input id="s1" type="text" name="email" value="<?php echo showres("email","SELECT email_address AS correo FROM reportes WHERE id_reporte='$idmodificar'");?>"/>
</td>
</tr>
<tr>
<td id="s2">COMMENTS:</td>
<td>
<input id="s1" type="text" name="comment" value="<?php echo showres("comment","SELECT comentario AS comentarios FROM reportes WHERE id_reporte='$idmodificar'");?>"/>
</td>
</tr>
<tr><td colspan="4" align="center"><input type="submit" value="Save"></form></td></tr>
</table>
</td>
<!--tercer columna xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx -->
</tr>
</table>
</td>
</tr>
<!-- ===================================================================================================================== -->
</table>
</td>
<td>
<?php
$sql="
SELECT teams.team AS team,
tipo_instancia.tipo AS instancia,
reportes.email_address AS email,
reportes.comentario AS comentario,
types.type AS type
FROM teams JOIN tipo_instancia JOIN reportes JOIN types
WHERE tipo_instancia.id_tipo_instancia=reportes.id_tipo_instancia
AND teams.id_team=reportes.id_team
AND types.id_type=reportes.id_type
AND id_reporte='$idmodificar'
";
showres("mostrar",$sql);
?>
</td>
</tr>
<tr>
<td align="center">
<?php echo "
<form method='post' action='borrarcontactos.php?tipo=$tipo&usuario=$usuario&transaccion=borrar'>
<input type='hidden' name='idborrar' value='$idmodificar'>
";?>
<input type="submit" value=" ELIMINAR CONTACTO "></form>
</td>
</tr>
</table>
</td>
