model_provinsi

 function getAll_ExtrasHotelProvinsi($id_prov) {
        $this->DBextras->select('h.hotel_id,h.hotel_name,h.hotel_address1,
        h.hotel_address2,h.hotel_phone,h.hotel_fax,h.hotel_email,h.hotel_website,
        h.hotel_image,h.hotel_thumbnail,h.id_prov,prov.nama_prov,h.id_kab,kab.nama_kab,h.hotel_is_lock,h.hotel_status,
        h.hotel_created_date,h.hotel_modified_date,h.hotel_user_id,prov.id_prov,kab.id_kab');
        $this->DBextras->from('hotel as h');
        $this->DBextras->join('provinsi as prov','h.id_prov = prov.id_prov');
        $this->DBextras->join('kabupaten as kab','h.id_kab = kab.id_kab');
        $this->DBextras->where('hotel_status', '1');
        $this->DBextras->where('h.id_prov', $id_prov);
        $this->DBextras->order_by('hotel_id', 'asc');
        $sql = $this->DBextras->get();
        $ret = $sql->result_array();
        $sql->free_result();
        return $ret;
    }