i want to update two fields from a table called Leave Request but when i click on the submit button.
<?php
$stmt = $pdo->prepare('UPDATE dbo.[TABLE$Leave Request] dbo.[KPMG$Leave Request].supAprrove_date=?,dbo.[TABLE$Leave Request].supAprrove=? WHERE dbo.[TABLE$Leave Request].id=?');
$stmt->execute(array($adate, $approve, $id));
$adate = $_POST['supAprrove_date'];
$approve =$_POST['supAprrove'];
$id = $_POST['lid'];
//$affected_rows = $stmt->rowCount();
?>
<form id="form1" name="form1" method="post" action="pending_leave.php">
<label>
<select name="supAprrove" id="supAprrove">
<option value="1">Approve</option>
<option value="2">Reject</option>
</select>
</label>
<input name="supAprrove_date" type="hidden" id="supAprrove_date" value="<?php echo date('Y-m-d'); ?>" />
<input type="hidden" name="lid" id="lid" value="<?php echo $data['id']; ?>"/>
<label>
<input type="submit" name="button" id="button" value="Submit" />
</label>
</form>