From 01032479e76f23194a60f1eef950c87bef033176 Mon Sep 17 00:00:00 2001
From: Alan Jack Pippin <ajp@pippin.(none)>
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