From 41d91db9360812279b61e135148b1fc9a189edd0 Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Fri, 7 Apr 2017 17:04:49 -0400 Subject: [PATCH] using steve's inner join to get the member type name instead of 2 queries --- models/front/fields/list.php | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) diff --git a/models/front/fields/list.php b/models/front/fields/list.php index bd5b3a9..646a3e3 100644 --- a/models/front/fields/list.php +++ b/models/front/fields/list.php @@ -66,14 +66,10 @@ class GlmMembersFront_fields_list extends GlmDataFieldsCustomFields $fields_data = new GlmDataFieldsCustomFieldsData($this->wpdb, $this->config); $field_values = $fields_data->getList($where); - $sql = "SELECT member_type FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "members WHERE id = $member_id;"; - $member_type_id = $wpdb->get_results($sql); - $member_type_id = $member_type_id[0]->member_type; + $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; - $sql = "SELECT name FROM " . GLM_MEMBERS_PLUGIN_DB_PREFIX . "member_type WHERE id = $member_type_id;"; - $member_type = $wpdb->get_results($sql); - $member_type = $member_type[0]->name; - foreach( $field_values as $key=>$value ){ $field_id = $value['field_id']; $field_value = $value['field_data']; -- 2.17.1