<?php require_once('open_connection.php');?>
<html>
<body bgcolor="black">
  <?php
 					
					$quotation_id = $_GET['quotation_id'];
					
                    $del_query=mysql_query("SELECT  tbl_dir_fnb_rquotation.quotation_id,tbl_dir_fnb_ritem.item_id, tbl_dir_fnb_ritem.item_description,tbl_dir_fnb_ritem.item_qty,
					                        tbl_dir_fnb_ritem.item_unit_price,tbl_dir_fnb_ritem.item_total
                                            FROM tbl_dir_fnb_rquotation
                                            LEFT JOIN tbl_dir_fnb_ritem ON tbl_dir_fnb_rquotation.quotation_id = tbl_dir_fnb_ritem.quotation_id where  tbl_dir_fnb_rquotation.quotation_id=".$quotation_id);
					 
                    $row=mysql_fetch_array($del_query);
                    $item_id=$row['item_id'];
					$quotation_id=$row['quotation_id'];
					
                ?>
				<h2>Add item_id to <?php echo $row['item_id']?></h2>
				<h2>Add quotation_id to <?php echo $row['quotation_id']?></h2>
				
<?php

			
			mysql_query("DELETE FROM tbl_dir_fnb_ritem where item_id= '$item_id'");
			echo "<script> alert('1 record deleted');
window.location.href='quotation_addOrder_Ramadhan.php?quotation_id=$quotation_id';
</script>";
?>
</body>
</html>