-$sql = "SELECT description, units, last_cost, actual_cost, material_cost, labour_cost,
- overhead_cost, mb_flag
- FROM ".TB_PREF."stock_master
- WHERE stock_id='" . $_POST['stock_id'] . "'
- GROUP BY description, units, last_cost, actual_cost, material_cost, labour_cost, overhead_cost, mb_flag";
-$result = db_query($sql);
-check_db_error("The cost details for the item could not be retrieved", $sql);
-
-$myrow = db_fetch($result);
-
-hidden("OldMaterialCost", $myrow["material_cost"]);
-hidden("OldLabourCost", $myrow["labour_cost"]);
-hidden("OldOverheadCost", $myrow["overhead_cost"]);