Solved. . . .
new error
function referrers($limit = 25)
{
$this->result = $GLOBALS['db']->raw_query('SELECT `url`, COUNT(*) AS `count` FROM `'.$GLOBALS['conf']['prefix'].'stats_referrers` GROUP BY `url` ORDER BY `count` DESC LIMIT '.$limit, 'stats_referrers');
if ($this->result[0]) {
foreach ($this->result as $key => $val) {
if (strlen($this->result[$key]['url']) > 75) {
$this->result[$key]['title'] = substr($this->result[$key]['url'], 0, 55).'...'.substr($this->result[$key]['url'], -20, 20);
} else {
$this->result[$key]['title'] = $this->result[$key]['url'];
}
}
}
return $this->result;
}
'SELECT `url`, COUNT(*) AS `count` FROM `'.$GLOBALS['conf']['prefix'].'stats_referrers` GROUP BY `url` ORDER BY `count` DESC LIMIT '.$limit, 'stats_referrers'
String in LIMIT?