function del_prod_procurement($pr_id, $d_id) { $sql = "DELETE FROM ITEMS ,DEAL_ITEMS_LIST\r\t\tUSING DEAL_ITEMS_LIST\r\t\tINNER JOIN ITEMS ON ITEMS.I_ID = DEAL_ITEMS_LIST.DIL_I_ID\r\t\tWHERE \r\t\tDEAL_ITEMS_LIST.DIL_D_ID=" . $d_id . " \r\t\tAND \r\t\tITEMS.I_PR_ID=" . $pr_id . " ;"; $result = $this->mysqli->query($sql); return trade::edit_procurement_form($d_id); }