X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=inc%2Fclass.eq.inc.php;fp=inc%2Fclass.eq.inc.php;h=c7601008cc1bcb0f13c2cba2fcc2598999e22d81;hb=8c3a64633fe59a227723d29b6965a6a7b6dd2d73;hp=328b1ab47fc75869b61cdffb2a98c073a631d945;hpb=759d76b818ce63f221215f8521b246fd61ab3976;p=eq%2F.git diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index 328b1ab..c760100 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -235,12 +235,11 @@ class eq $this->t->set_var('district_number',$districts[$i]['district']); $this->t->set_var('district_name',$districts[$i]['name']); $supervisor = $districts[$i]['supervisor']; - $unique_companionships=''; // Select all the unique companionship numbers for this district $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district']; $this->db->query($sql,__LINE__,__FILE__); - $j=0; + $j=0; $unique_companionships = ''; while ($this->db->next_record()) { $unique_companionships[$j]['companionship'] = $this->db->f('companionship'); @@ -418,7 +417,7 @@ class eq // Get a list of all the companionships in this district $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); - $j=0; + $j=0; $unique_companionships = ''; while ($this->db->next_record()) { $unique_companionships[$j]['companionship'] = $this->db->f('companionship'); @@ -485,7 +484,7 @@ class eq // Select all the unique companionship numbers for this district $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); - $j=0; $unique_companionships=''; + $j=0; $unique_companionships = ''; while ($this->db->next_record()) { $unique_companionships[$j]['companionship'] = $this->db->f('companionship'); @@ -1921,7 +1920,7 @@ class eq // Select all the unique companionship numbers for this district $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$d]['district']; $this->db->query($sql,__LINE__,__FILE__); - $j=0; + $j=0; $unique_companionships = ''; while ($this->db->next_record()) { $unique_companionships[$j]['companionship'] = $this->db->f('companionship'); @@ -2735,13 +2734,11 @@ class eq $this->t->set_var('district_number',$districts[$i]['district']); $this->t->set_var('district_name',$districts[$i]['name']); $supervisor = $districts[$i]['supervisor']; - $unique_companionships=''; // Select all the unique companionship numbers for this district $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $districts[$i]['district']; - $this->db->query($sql,__LINE__,__FILE__); - $j=0; + $j=0; $unique_companionships = ''; while ($this->db->next_record()) { $unique_companionships[$j]['companionship'] = $this->db->f('companionship');