- $curr = get_company_currency();
- $sql = "SELECT account_code FROM ".TB_PREF."bank_accounts
- WHERE account_code = '".$_POST['account_code']."'";
- if ($curr == $_POST['BankAccountCurrency'])
- $sql .= " AND bank_curr_code <> '".$_POST['BankAccountCurrency']."'";
- $sql .= " AND id <> $selected_id";
- $result = db_query($sql,"could not get bank accounts");
- if (db_num_rows($result) > 0)
- {
- $input_error = 1;
- display_error(_("The GL account is already in use."));
- set_focus('account_code');
- }