function edit(){
$id = $_GET['id'];
$PID = $_GET['pid'];
$orig = $_GET['orig'];
$beg_qty = $_GET['beg_qty'];
$supplier = $_GET['supplier'];
$pur_price =$_GET['pur_price'];
$sel_price = $_GET['sel_price'];
$date_pur = $_GET['date_pur'];
$exp = $_GET['exp'];

@ $db = mysql_pconnect('localhost', 'xx', 'xx');
mysql_select_db('avh');

if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}

$query = "update Item_In_Stock set Date_Purchased='".$date_pur."', Expiration='".$exp."', Beginning_qty=".$beg_qty.",Supplier_ID='".$supplier."' where purchase_ID='".$PID."'";
$result = mysql_query($query) or die(mysql_error());
if($orig!=$sel_price){
$qry = "insert into Item_Price(Purchase_ID,Price,Price_date) values (".$PID.", ".$sel_price.",'".$date."')";
$res = mysql_query($query) or die(mysql_error());
}
}