- SELECT "
- .db_escape($trans_no).", ".db_escape($trans_type).", debtor_no,"
- .db_escape($branch_id).",'".date2sql($date)."', ".db_escape($ref).","
- .db_escape($amount).", ".db_escape($rate)."
- FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id);
-
+ VALUES (".db_escape($trans_no).", ".db_escape($trans_type).",
+ (SELECT debtor_no FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id). ") ,"
+ .db_escape($branch_id).",'".date2sql($date)."', ".db_escape($ref).","
+ .db_escape($amount).", ".db_escape($rate).")";