$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>