return $result; } function industry($atm_industry, $atm_sector) { if (!empty($atm_sector) && !empty($atm_industry)) { $select = mysql_query("SELECT indus_name FROM industrymst_atm WHERE indus_status='A' AND indus_sector_fk={$atm_sector} AND indus_pk={$atm_industry} "); if (mysql_num_rows($select) > 0) { $fetch = mysql_fetch_array($select); } $result = $fetch['indus_name']; } else { $result = ""; } return $result; } $dispsector = sector($atm_sector); $dispindustry = industry($atm_industry, $atm_sector); $content = <<<APPCOMP <!DOCTYPE html><html><body><table cellpadding='0' cellspacing='0' border='0' width='75%' align='center'> <tr><td style="font-weight:bold;" valign="top" colspan="2"><h3>Personal Details</h3></td></tr> <tr><td height="10"></td></tr> <tr><td style="font-weight:bold;" valign="top">Name</td><td valign="top"> : </td><td valign="top">{$atm_name}</td></tr> <tr><td height="5"></td></tr> <tr><td style="font-weight:bold;" valign="top">Email</td><td valign="top"> : </td><td valign="top">{$atm_email}</td></tr> <tr><td height="5"></td></tr> <tr><td style="font-weight:bold;" valign="top">Address</td><td valign="top"> : </td><td valign="top">{$atm_addr}</td></tr> <tr><td height="5"></td></tr> <tr><td style="font-weight:bold;" valign="top">Specification</td><td valign="top"> : </td><td valign="top">{$atm_busexpect}</td></tr> <tr><td height="10"></td></tr> <tr><td style="font-weight:bold;" valign="top" colspan="2"><h3>Business Details</h3></td></tr> <tr><td height="10"></td></tr>
<!-- <option value="0">Seleccionar...</option> --> <?php echo ejercicio($cnx); ?> </select> </div> </div> <div class="form-group"> <label class="col-md-2 control-label" for="sec">Sector:</label> <div class="col-md-3"> <select id="sec" name="sec" class="form-control"> <!-- <option value="0">Seleccionar...</option> --> <?php echo sector($cnx); ?> </select> </div> </div> <div class="form-group"> <label class="col-md-2 control-label" for="ue">Unidad Ejecutora:</label> <div class="col-md-4"> <select id="ue" name="ue" class="form-control"> <option value="0">Selecciona...</option> </select> </div> </div>