From 226b58bea9e0d7b371b532711b9b14c32477e1b3 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Tue, 23 Apr 2019 14:17:00 -0400 Subject: [PATCH] Update for city range search Need to set the whereSep if it is empty. --- models/front/members/list.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/models/front/members/list.php b/models/front/members/list.php index 81dfde43..a1eab391 100755 --- a/models/front/members/list.php +++ b/models/front/members/list.php @@ -1031,6 +1031,9 @@ class GlmMembersFront_members_list extends GlmDataMemberInfo $cityName = $cityCoordinates['name']; // Distance query $distanceQuery = $this->getDistanceQuery( $cityCoordinates['lat'], $cityCoordinates['lon'] ); + if ( !isset( $whereSep ) || $whereSep == '' ) { + $whereSep = ' AND '; + } $where .= $whereSep." ( $distanceQuery < 40 )"; $whereSep = ' AND '; $appendSelect = " -- 2.17.1