4 function get_branch($branch_id)
6 $sql = "SELECT ".TB_PREF."cust_branch.*,".TB_PREF."salesman.salesman_name
7 FROM ".TB_PREF."cust_branch, ".TB_PREF."salesman
8 WHERE ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code
9 AND branch_code=$branch_id";
11 $result = db_query($sql, "Cannot retreive a customer branch");
13 return db_fetch($result);
16 function get_branch_accounts($branch_id)
18 $sql = "SELECT receivables_account,sales_account, sales_discount_account, payment_discount_account
19 FROM ".TB_PREF."cust_branch WHERE branch_code=$branch_id";
21 $result = db_query($sql, "Cannot retreive a customer branch");
23 return db_fetch($result);
26 function get_branch_name($branch_id)
28 $sql = "SELECT br_name FROM ".TB_PREF."cust_branch
29 WHERE branch_code = '$branch_id'";
31 $result = db_query($sql,"could not retreive name for branch" . $branch_id);
33 $myrow = db_fetch_row($result);