if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$advance = $row['advance'];
}
$sql = "SELECT * FROM " . $mysql_table_prefix . "loan_employee where emp_id = '$emp_offical_edit1' ";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$loan = $row['loan_amount'];
}
}
if (isset($_POST['emp_offical'])) {
$test = $_POST['test'];
$date_joining = $_POST['date_joining'];
$date_joining = getdbdate($date_joining);
$date_joining = str_replace("/", "-", $date_joining);
$plant_name = $_POST['plant_name'];
$department = $_POST['department'];
$sub_department = $_POST['sub_department'];
$grade = $_POST['grade'];
$authority_name = $_POST['authority_name'];
$emp_type = $_POST['emp_type'];
$emp_category = $_POST['emp_category'];
$designation = $_POST['designation'];
$pf_no = $_POST['pf_no'];
$pf_rate = $_POST['pf_rate'];
$date_pf = $_POST['date_pf'];
$pf_nominee = $_POST['pf_nominee'];
$pf_relationship = $_POST['pf_relationship'];
$pf_deduction = $_POST['pf_deduction'];
<td align="center"><?php
echo $row_emp['ticket_no'];
?>
</td>
<td align="left">
<?php
echo $row_emp['first_name'];
?>
<?php
echo $row_emp['last_name'];
?>
</td>
<!--<td align="left">
<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row_emp['emp_id'], getdbdate($date)));
?>
</td>-->
<td align="center">
<?php
echo $row_emp['good_work'];
?>
</td>
</tr>
<?php
$s++;
}
}
?>
