<tr>
<td height="16px" colspan="4" align="center"><?php
print isset($msg) ? $msg : "";
?>
<span id="msg" class="error"></span></td>
</tr>
<tr>
<td align="center" colspan="4"><img src="images/blank.gif" alt="" height="2px" /></td>
</tr>
<tr>
<td align="left"><span class="error">*</span>Subdivision Name</td>
<td align="left"><select name="subdivision" id="subdivision" style="width:200px;" >
<option value='0'>Select</option>
<?php
$districtcd = $dist_cd;
$rsSubDiv = fatch_Subdivision($districtcd);
$num_rows = rowCount($rsSubDiv);
for ($i = 1; $i <= $num_rows; $i++) {
$rowSubDiv = getRows($rsSubDiv);
echo "<option value='{$rowSubDiv['subdivisioncd']}'>{$rowSubDiv['subdivision']}</option>";
unset($rowSubDiv);
}
unset($num_rows, $rsSubDiv);
?>
</select></td>
<td colspan="2"> </td>
</tr>
<tr>
<td align="left"><span class="error">*</span>Block/Municipality Name</td>
<td align="left"><input type="text" name="block_muni" id="block_muni" style="width:192px;" /></td>
<td align="left">Block/Municipality</td>
<div class="overlay">
<img id="loading_spinner" src="images/loading1.gif" height="80px" width="80px" />
</div>
</td>
</tr>
<tr>
<td align="left"><input type="checkbox" id="chksetsubdivision" name="chksetsubdivision" onclick="return chksetsubdivision_change();" />
<label for="chksetsubdivision" class="text_small">Sub division wise<br />
</label></td>
<td align="left" valign="top"><span class="error">*</span>Sub Division</td>
<td align="left" valign="top"><select name="Subdivision" id="Subdivision" style="width:170px;" disabled="disabled" onchange="fatch_office_agsubdiv(this.value)">
<option value="0">-Select Subdivision-</option>
<?php
$districtcd = $dist_cd;
$rsBn = fatch_Subdivision($districtcd);
$num_rows = rowCount($rsBn);
if ($num_rows > 0) {
for ($i = 1; $i <= $num_rows; $i++) {
$rowBn = getRows($rsBn);
echo "<option value='{$rowBn['0']}'>{$rowBn['2']}</option>\n";
}
}
$rsBn = null;
$num_rows = 0;
$rowBn = null;
?>
</select></td>
<td align="left" valign="top"><span class="error">*</span>For Sub Division</td>
<td align="left" valign="top" style="width:170px;"><label id="forsubdivision_name" name="forsubdivision_name"></label>
<input type="hidden" id="forsubdivision" name="forsubdivision" /></td>
<tr><td align="center"><?php
print $district;
?>
DISTRICT</td></tr>
<tr><td align="center">APPOINTMENT LETTER FOR TRAINING</td></tr>
<tr><td align="center" valign="top"><form method="post" name="form1" id="form1">
<table width="95%" class="form" cellpadding="0">
<tr>
<td align="center" colspan="4"><img src="images/blank.gif" alt="" height="1px" /></td>
</tr>
<tr><td align="left" valign="top"><span class="error">*</span>Sub Division</td>
<td align="left" valign="top"><select name="subdivision" id="subdivision" style="width:200px;">
<option value="0">-Select Subdivision-</option>
<?php
$rsSubDiv = fatch_Subdivision();
$num_rows = rowCount($rsSubDiv);
if ($num_rows > 0) {
for ($i = 1; $i <= $num_rows; $i++) {
$rowSubDiv = getRows($rsSubDiv);
echo "<option value='{$rowSubDiv['0']}'>{$rowSubDiv['2']}</option>\n";
}
}
$rsSubDiv = null;
$num_rows = 0;
$rowSubDiv = null;
?>
</select></td> <td align="left"><span class="error"> </span>Office ID</td>
<td align="left"><input type="text" name="officeID" id="officeID" style="width:250px;" /></td> </tr>
<tr>
if ($num_rows > 0) {
for ($i = 1; $i <= 2; $i++) {
$rowTrainingType = getRows($rsTrainingType);
echo "<option value='{$rowTrainingType['0']}' >{$rowTrainingType['1']}</option>\n";
$rowTrainingType = NULL;
}
}
unset($rsTrainingType, $num_rows, $rowTrainingType);
?>
</select></td></tr>
<tr>
<td align="left"><span class="error">*</span>Subdivision</td>
<td align="left"><select name="subdivision" id="subdivision" style="width:200px;">
<option value="0">-Select Subdivision-</option>
<?php
$rsSubDiv = fatch_Subdivision($dist_cd);
$num_rows = rowCount($rsSubDiv);
if ($num_rows > 0) {
for ($i = 1; $i <= $num_rows; $i++) {
$rowSubDiv = getRows($rsSubDiv);
echo "<option value='{$rowSubDiv['0']}'>{$rowSubDiv['2']}</option>\n";
$rowSubDiv = NULL;
}
}
unset($rsSubDiv, $num_rows, $rowSubDiv);
?>
</select></td></tr>
<tr id="trSubdiv" style="visibility:hidden;"><td align="left"> </td><td align="left"> </td></tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Select PP" class="button" onclick="javascript:return validate();" /></td></tr>
<?php
session_start();
extract($_GET);
include_once 'inc/db_trans.inc.php';
include_once 'function/add_fun.php';
include_once 'function/user_fun.php';
include_once 'function/pagination.php';
$opn = isset($_GET["opn"]) ? $_GET["opn"] : "";
$dist = isset($_GET["dist"]) ? $_GET["dist"] : "";
$userid = isset($_GET["userid"]) ? $_GET["userid"] : "";
$category = isset($_GET["category"]) ? $_GET["category"] : "";
$delcode = isset($_GET["delcode"]) ? $_GET["delcode"] : "";
if ($opn == "subdiv") {
$dist = $_GET["dist"];
$rsSubdiv = fatch_Subdivision($dist);
$num_rows = rowCount($rsSubdiv);
echo "<select name='subdiv' id='subdiv' style='width:200px;' onchange='return subdiv_change(this.value);'>";
if ($num_rows > 0) {
echo "<option value='0'>-Select Subdivision-</option>";
for ($i = 1; $i <= $num_rows; $i++) {
$rowSubdiv = getRows($rsSubdiv);
echo "<option value='{$rowSubdiv['0']}'>{$rowSubdiv['2']}</option>";
}
}
echo "</select>";
unset($rsSubdiv, ${$num_rows}, $rowSubdiv);
}
if ($opn == "pc") {
$subdiv = $_GET["subdiv"];
$rsPC = fatch_pc($subdiv);
