Hi,
i find the solution.
Add this to that column
Than create a page with approve.php
then add this code there
<?php
include("../dbconfig.php");
$id=$_REQUEST['apply_id'];
$query="update apply_leave set status1='approve' where apply_id='".$id."'";
if(!mysql_query($query,$con))
{
die ("An unexpected error occured while saving the record, Please try again!");}
else
{
header("Location:http://localhost/Mysql/Intranetportal/admin/leave-request.php");
}
?>
Have fun!!!