for ($i = 1; $i <= $num_rows; $i++) { $rowpol = getRows($rspol); echo "<option value='{$rowpol['0']}'>{$rowpol['2']}</option>\n"; } } $rspol = null; $rowpol = null; } ?> </select> </span> <br /> </td> <td align="left"><span class="error">*</span>Block/Municipality</td> <td align="left"> <span id='Block_result'><select name="Municipality" id="Municipality" style="width:150px;"> <?php if (isset($offccd)) { $rsblock = fatch_block($rowOffice['subdivisioncd']); $num_rows = rowCount($rsblock); if ($num_rows > 0) { echo "<option value='0'>-Select Block/Municipality-</option>\n"; for ($i = 1; $i <= $num_rows; $i++) { $rowblock = getRows($rsblock); echo "<option value='{$rowblock['0']}'>{$rowblock['2']}</option>\n"; } } $rspol = null; $rowpol = null; } ?> </select></span> </td> </tr> <tr>
if ($rowofc['officecd'] == NULL) { if ($subdiv != "0000") { $ofccd = sprintf("%08d", $subdiv . "0001"); } else { $ofccd = ""; } } else { $ofccd = sprintf("%08d", $rowofc['officecd'] + 1); } echo "<input type='text' name='OfficeID' id='OfficeID' style='width:142px;' value='{$ofccd}' readonly='readonly' />\n"; } $rsofc = NULL; $rowofc = NULL; unset($rsofc, $rowofc, $num_rows); } else { $rsblock = fatch_block($subdiv); $num_rows = rowCount($rsblock); if ($num_rows < 1) { echo "<select name='Municipality' id='Municipality' style='width:150px;'></select>"; } else { echo "<select name='Municipality' id='Municipality' style='width:150px;'>\n"; echo "<option value='0'>-Select Block/Municipality-</option>\n"; for ($i = 1; $i <= $num_rows; $i++) { $rowblock = getRows($rsblock); echo "<option value='{$rowblock['0']}'>{$rowblock['2']}</option>\n"; } echo "</select>\n"; } $rsblock = NULL; $rowblock = NULL; unset($rsblock, $rowblock, $num_rows);