private function content_group_query($controller, $format, $group, $params) { if (isset($params['id'])) { $tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type'; $columns = $controller . '.*'; $where = 'content_lookup.content_id=content.contentid AND content_lookup.content_type_id=content_type.content_type_id AND content_lookup.content_group_id=content_group.content_group_id AND content_type.content_type_name=? AND content_group.content_group_name=? AND content_lookup.taxa_id=?'; $fields = array($format, $group, $params['id']); //build single query from BuildQuery class $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); self::$db_content_group = $db_results; } }
private function content_group_query($controller, $format, $group, $params) { if (isset($params['id'])) { $tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type'; $columns = $controller . '.*'; $where = DB_CONTENT_LOOKUP . '.content_id=' . DB_CONTENT . '.contentid AND ' . DB_CONTENT_LOOKUP . '.content_type_id=' . DB_CONTENT_TYPE . '.content_type_id AND ' . DB_CONTENT_LOOKUP . '.content_group_id=' . DB_CONTENT_GROUP . '.content_group_id AND ' . DB_CONTENT_TYPE . '.content_type_name=? AND ' . DB_CONTENT_GROUP . '.content_group_name=? AND ' . DB_CONTENT_LOOKUP . '.taxa_id=? ORDER BY ' . DB_CONTENT . '.contentid'; $fields = array($format, $group, $params['id']); //build single query from BuildQuery class $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); self::$db_content_group = $db_results; } }