From 01032479e76f23194a60f1eef950c87bef033176 Mon Sep 17 00:00:00 2001 From: Alan Jack Pippin Date: Tue, 24 Jan 2006 12:45:36 -0700 Subject: [PATCH] Fixed bug related to ht_update visited column width. Fixed bug related to invalid ht companionships being displayed in ht_update view. --- inc/class.eq.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php index 8c2984e..069b3ae 100644 --- a/inc/class.eq.inc.php +++ b/inc/class.eq.inc.php @@ -386,7 +386,7 @@ class eq } // Select all the unique companionship numbers for this district - $sql = "SELECT distinct companionship FROM eq_companionship where district=". $district; + $sql = "SELECT distinct companionship FROM eq_companionship where valid=1 and district=". $district; $this->db->query($sql,__LINE__,__FILE__); $j=0; $unique_companionships=''; while ($this->db->next_record()) @@ -395,7 +395,7 @@ class eq $j++; } - $comp_width=300; $visit_width=25; $table_width=$comp_width + $num_months*$visit_width; + $comp_width=300; $visit_width=25; $table_width=$comp_width + $visit_width; $table_data=""; $num_companionships = 0; $num_families = 0; $visits=0; for ($j=0; $j < count($unique_companionships); $j++) { $companion_table_entry = ""; -- 2.34.1