From 84312a79585ca80e2a16ac1d6df8f2f8ea7789ab Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 7 Jun 2013 19:15:13 +0000 Subject: [PATCH] update city part --- Toolkit/Members/TripPlannerList.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/Toolkit/Members/TripPlannerList.php b/Toolkit/Members/TripPlannerList.php index 5f05914..33d3162 100644 --- a/Toolkit/Members/TripPlannerList.php +++ b/Toolkit/Members/TripPlannerList.php @@ -110,10 +110,10 @@ class Toolkit_Members_TripPlannerList $page = $this->pageGateway->find($catid); $ancestors[$count]['id'] = $catid; $ancestors[$count]['label'] = $page['navigation_name']; - $ancestors[$count]['link'] + $ancestors[$count]['link'] = Toolkit_Template_Page::getSeoUrl($this->pageGateway, $catid); $this->getAncestors($page['parent'], ++$count); - $ancestors[$count]['link'] + $ancestors[$count]['link'] = Toolkit_Template_Page::getSeoUrl($this->pageGateway, $res['id']); $this->getAncestors($res['parent'], ++$count); @@ -162,8 +162,8 @@ class Toolkit_Members_TripPlannerList s.state_abb AS state_abbr, m.street||', '||c.city_name||', '||s.state_name||', '||m.zip AS address FROM member m - JOIN state s USING (state_id) - JOIN city c USING (city_id) + LEFT OUTER JOIN state s ON (m.state_id = s.state_id) + LEFT OUTER JOIN city c ON (m.city_id = c.city_id) WHERE member_id = :member_id"; $stmt = $this->dbh->prepare($sql); if (is_array($members)) { -- 2.17.1