From 0ba310089373dd8c0ddb7091c56a5b7c15c249b2 Mon Sep 17 00:00:00 2001
From: Alan Jack Pippin <ajp@pippin.(none)>
Date: Sun, 12 Mar 2006 23:36:35 -0700
Subject: [PATCH] Fixed HT apps to sort families under a companionship in
 alphabetical order.

---
 inc/class.eq.inc.php | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/inc/class.eq.inc.php b/inc/class.eq.inc.php
index 3478b4c..aa60481 100644
--- a/inc/class.eq.inc.php
+++ b/inc/class.eq.inc.php
@@ -216,6 +216,7 @@ class eq
 	  
 	  // Get the names of the families assigned this home teaching companionship
 	  $sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship'];
+	  $sql = $sql . " ORDER BY name ASC";
 	  $this->db->query($sql,__LINE__,__FILE__);
 	  $k=0;
 	  while ($this->db->next_record())
@@ -441,6 +442,7 @@ class eq
 	
 	// Get the names of the families assigned this home teaching companionship
 	$sql = "SELECT * from eq_family where valid=1 AND companionship=".$unique_companionships[$j]['companionship'];
+	$sql = $sql . " ORDER BY name ASC";
 	$this->db->query($sql,__LINE__,__FILE__);
 	while ($this->db->next_record())
 	  {
-- 
2.34.1