protected function calculatePercentile($details) { $limit = (int) ($details['count'] / 20); $query = "SELECT `{$details['column']}` as `value` FROM `details` WHERE `{$details['type']}` = '{$details['url']}' ORDER BY `{$details['column']}` DESC LIMIT {$limit}, 1"; $rs = $this->db->query($query); $row = $this->db->getNextAssoc($rs); return $row['value']; }
protected function calculatePercentile($details) { $limit = (int) ($details['count'] / 20); $query = "SELECT {$details['column']} as value FROM system_profiler WHERE {$details['type']} = '{$details['url']}' ORDER BY {$details['column']} DESC LIMIT 1 OFFSET {$limit}"; $rs = $this->db->query($query); $row = $this->db->getNextAssoc($rs); return $row['value']; }