From 8c3a64633fe59a227723d29b6965a6a7b6dd2d73 Mon Sep 17 00:00:00 2001 From: "Alan J. Pippin" Date: Wed, 8 Sep 2010 14:44:34 -0600 Subject: [PATCH] Fixed initialization issue with unique_companionships array --- inc/class.eq.inc.php | 13 +++++-------- 1 file changed, 5 insertions(+), 8 deletions(-) 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'); -- 2.34.1