<?php require_once('open_connection.php');?>

				<?php
				
					$item_id = $_REQUEST['item_id'];
					$result1=mysql_query("select * from tbl_dir_fnb_item where item_id='$item_id'");
			   						 
                    $row=mysql_fetch_array($result1);
                    $item_id=$row['item_id'];
					$quotation_id=$row['quotation_id'];
                ?>
               
				<!--h2>Add spm_id to <?php echo $row['item_id']?></h2-->
				<?php
						     $item_id = $_POST['item_id'];
					$item_description = $_POST['item_description'];
					        $item_qty = $_POST['item_qty'];
					 $item_unit_price = $_POST['item_unit_price'];
					       $item_total= $item_qty*$item_unit_price;
					  

	mysql_query("UPDATE tbl_dir_fnb_item SET item_description='".$item_description."',item_qty ='".$item_qty."',
	            item_unit_price ='".$item_unit_price."', item_total ='".$item_total."' where item_id='".$item_id."'");
				echo "<script> alert('1 record updated');
				
				window.location.href='untitled3.php?quotation_id=$quotation_id';
				
	</script>";
	mysql_close($con);
?>

