hi,

I have a problem in updating database.Basically the project is Warden approval/Rejection of leave forms.There is a field called "status" in a table named "general". Basically the default status in the database I kept is pending. While I click on submit button either to approve or reject the request,the database is not updating to approve or reject.It is showin me pending itself.

Can any one help me out.
I tried the following code.

if ($_POST[status] == "approve")
{

$query="UPDATE general SET status= \"approved\" WHERE status= \"pending\"";
}
if ($_POST[status] == "reject")
{
$query="UPDATE general SET status='rejected' WHERE status='pending'";
}

Is tis code correct.Or iz there any other code for it.
Please help me out.[attachmentid=4335][attachmentid=4335][attachmentid=4335][attachmentid=4335]