From a374fb3397da1c5cb3e94898133298c90d676165 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Mon, 8 Jul 2013 20:07:30 +0000
Subject: [PATCH] update search form

Order the counties by name
---
 Toolkit/Members/UserSearchForm.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/Toolkit/Members/UserSearchForm.php b/Toolkit/Members/UserSearchForm.php
index 9c42e0e..bb22c83 100644
--- a/Toolkit/Members/UserSearchForm.php
+++ b/Toolkit/Members/UserSearchForm.php
@@ -815,7 +815,8 @@ class Toolkit_Members_UserSearchForm
             SELECT DISTINCT county
               FROM member
              WHERE active
-               AND county is not null)";
+               AND county is not null)
+        ORDER BY county_name";
             $stmt = $this->dbh->prepare($sql);
             $stmt->execute();
             while ($row = $stmt->fetch()) {
-- 
2.17.1