Creating Active Record Query

[eluser]Karman de Lange[/eluser]
try

Code:

$this->db->select($this->titles_table.'.title_name');
$this->db->select($this->roster_table.'.condender_no');

$this->db->select($this->roster_table.'.roster_name');
        $sl = "CASE WHEN $this->title_champions_table.contender_no = 0 THEN 'Champion' ELSE 'Contender' END as champion"
$this->db->select($sl,false);

$this->db->from($this->titles_table);
$this->db->join($this->roster_table, $this->titles_table.'.roster_id ='. $this->roster_table.'.id', 'inner');
$this->db->join($this->title_champions_table, $this->titles_table.'.id ='. $this->title_champions_table.'.title_id', 'inner');
      
$query = $this->db->get();

just make sure you escape all correctley as the false sayd don't escape.

L: