concatenated query

[eluser]mistress_shiira[/eluser]
hello guys!i was wondering how will i be able to concatenate this following query:

$this->db->select('CID');
$this->db->from('cpa_campaigns');
$this->db->join('campaign_period_enum','cpa_campaigns.PeriodEnum','left');
$this->db->where('DisableCampaign !=',1);
$this->db->orderby('CID','asc');

and get their result using $query->result() ?

[eluser]Developer13[/eluser]
The way you posted it should work just fine... after your $this->db calls, simply do this:

$query = $this->db->get();
$results = $query->result();

Are you getting an error or something?