Код: Выделить всё
$query = $this->db->get_where('navigation', 'linkname IS NOT NULL
AND parent IS NULL
AND type="main" //this doesn't work!!
AND ORDER BY sortnumber ASC');
Подробнее здесь: https://stackoverflow.com/questions/102 ... -get-where
Код: Выделить всё
$query = $this->db->get_where('navigation', 'linkname IS NOT NULL
AND parent IS NULL
AND type="main" //this doesn't work!!
AND ORDER BY sortnumber ASC');