echo "<option value='{$rowBn['0']}'>{$rowBn['2']}</option>";
}
}
$rsBn = null;
$num_rows = 0;
$rowBn = null;
$districtcd = 0;
?>
</select></td>
</tr>
<tr>
<td align="left"><span class="error">*</span>Police Station</td>
<td align="left"><span id='Police_Station'><select name="PoliceStation" id="PoliceStation" style="width:150px;">
<?php
if (isset($offccd)) {
$rspol = fatch_PoliceStation($rowOffice['subdivisioncd']);
$num_rows = rowCount($rspol);
if ($num_rows > 0) {
echo "<option value='0'>-Select Police Station-</option>\n";
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>
$rowBranch = NULL;
unset($rsBranch, $rowBranch, $num_rows);
} else {
$rsBranch = NULL;
unset($rsBranch);
}
//=============== Fatch Block/Municipality & Police Station===================
$subdiv;
$pol;
$ofcid;
$subdiv = isset($_GET["subdiv"]) ? $_GET["subdiv"] : "";
$pol = isset($_GET["pol"]) ? $_GET["pol"] : "";
$ofcid = isset($_GET["ofcid"]) ? $_GET["ofcid"] : "";
if ($subdiv != '') {
if ($pol == 'n') {
$rspol = fatch_PoliceStation($subdiv);
$num_rows = rowCount($rspol);
if ($num_rows < 1) {
echo "<select name='PoliceStation' id='PoliceStation' style='width:150px;'></select>";
} else {
echo "<select name='PoliceStation' id='PoliceStation' style='width:150px;'>\n";
echo "<option value='0'>-Select Police Station-</option>\n";
for ($i = 1; $i <= $num_rows; $i++) {
$rowpol = getRows($rspol);
echo "<option value='{$rowpol['0']}'>{$rowpol['2']}</option>\n";
}
echo "</select>\n";
}
$rspol = NULL;
$rowpol = NULL;
unset($rspol, $rowpol, $num_rows);
