-
- // Get the EQ President
- $sql = "SELECT * FROM tc_presidency where president=1 and valid=1";
- $this->db->query($sql,__LINE__,__FILE__);
- if($this->db->next_record()) {
- $president_name = $this->db->f('name');
- $president_name_array = explode(",",$president_name);
- $president_last_name = $president_name_array[0];
- $president_id = $this->db->f('indiv');
- $presidency_id = $this->db->f('presidency');
- $interviewer = $this->db->f('indiv');
- $district_number = '*';
- $district_name = $president_name;
- $sql = "SELECT * FROM tc_indiv where indiv='$president_id'";
- $this->db2->query($sql,__LINE__,__FILE__);
- if($this->db2->next_record()) {
- $indiv_id = $this->db2->f('indiv_id');
- }
- $sql = "SELECT * FROM tc_indiv where indiv_id='$indiv_id'";
- $this->db2->query($sql,__LINE__,__FILE__);
- if($this->db2->next_record()) {
- $president_address = $this->db2->f('address');
- }
- } else {
- print "<hr><font color=red><h3>-E- Unable to locate President in tc_presidency table</h3></font></hr>";
- return;
- }