$idactual=showres("consultaridactual","SELECT id_tipo_instancia AS idactual FROM reportes WHERE id_reporte='$idmodificar' ");
selectmenu("SELECT * FROM tipo_instancia","<option value=\"{id}\" {selectedtype}>{nombre}</option>\n");
?>
</select>
</td>
</tr>
<tr>
<td id="s2">TYPE:</td>
<td>
<select name="type" id="s3">
<?php
$idactual=showres("consultaridactual","SELECT id_type AS idactual FROM reportes WHERE id_reporte='$idmodificar' ");
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'");?>"/>
$ver="
<tr>
<td width=\"40\" bgcolor=\"{color}\">{team}</td>
<td width=\"40\" bgcolor=\"{color}\">{program}</td>
<td width=\"80\" align=\"center\" bgcolor=\"{color}\">{agent}</td>
<td width=\"90\" align=\"center\" bgcolor=\"{color}\">{ddate}</td>
<td width=\"90\" align=\"center\" bgcolor=\"{color}\">{channel}</td>
<td width=\"170\" align=\"center\" bgcolor=\"{color}\">{email}</td>
<td width=\"200\" align=\"center\" bgcolor=\"{color}\">{type}</td>
<td width=\"140\" align=\"center\" bgcolor=\"{color}\">{comments}</td>
<td><a href='modificarreportes.php?id={idreporte}&transaccion=edit&usuario=$usuario&tipo=$tipo'>
<img src='../images/lapiz.png' border='0'></a></td>
<td><a href='borrarcontactos.php?id={idreporte}&transaccion=edit&usuario=$usuario&tipo=$tipo'>
<img src='../images/x.png' border='0' alt='Borrar'></a></td>
</tr>";
selectmenu($sql,$ver);
;
?>
</table>
</td></tr>
</table>
</td></tr>
<!-- TERMINA SEGUNDA COLUMNA -->
</table>
<div style="width:900px;"></div>
</body>
</html>
