- $sql = "SELECT ".TB_PREF."suppliers.supplier_id,
- ".TB_PREF."suppliers.supp_name,
- ".TB_PREF."suppliers.address,
- ".TB_PREF."suppliers.supp_address,
- ".TB_PREF."suppliers.supp_ref,
- ".TB_PREF."suppliers.contact,
- ".TB_PREF."suppliers.curr_code,
- ".TB_PREF."suppliers.dimension_id,
- ".TB_PREF."suppliers.dimension2_id,
- ".TB_PREF."suppliers.notes,
- ".TB_PREF."suppliers.gst_no
- FROM ".TB_PREF."suppliers
- WHERE inactive = 0
- ORDER BY supp_name";
+ $sql = "SELECT supplier_id, supp_name, address, supp_address, supp_ref,
+ contact, curr_code, dimension_id, dimension2_id, notes, gst_no
+ FROM ".TB_PREF."suppliers
+ WHERE inactive = 0
+ ORDER BY supp_name";