From 8e976ac3c665980d0e9c7f9b3da9170bce0aa58a Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Fri, 7 Apr 2017 17:02:29 -0400 Subject: [PATCH] Add another where part for the member type query. To get only those that match both tables. --- models/front/fields/detail.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/models/front/fields/detail.php b/models/front/fields/detail.php index 2b3eab0..e0e5c96 100644 --- a/models/front/fields/detail.php +++ b/models/front/fields/detail.php @@ -66,7 +66,7 @@ class GlmMembersFront_fields_detail extends GlmDataFieldsCustomFields $fields_data = new GlmDataFieldsCustomFieldsData($this->wpdb, $this->config); $field_values = $fields_data->getList($where); - $sql = "SELECT mt.name FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_type mt, " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members m WHERE m.id = $member_id;"; + $sql = "SELECT mt.name FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_type mt, " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members m WHERE m.id = $member_id AND mt.id = m.member_type"; $member_type = $wpdb->get_results($sql); $member_type = $member_type[0]->name; -- 2.17.1