Is there a CodeIgniter function for returning the first row in a query?

Is there a CodeIgniter function available to directly return the first row when performing a database query that should only result in one row? Currently, I'm using the following code:


...query stuff...
$query = $this->db->get();
$ret = $query->result();
return $ret[0]->campaign_id;
I'm wondering if there's a more efficient way, such as a function like $query->row(), to retrieve just the first row from the query result.

Alternatively, it would be even better if I could directly access the campaign_id from the query object itself, like $query->campaign_id, especially when there's only one row in the result set.

Is there a CodeIgniter function available to directly return the first row when performing a database query that should only result in one row? Currently, I'm using the following code:


...query stuff...
$query = $this->db->get();
$ret = $query->result();
return $ret[0]->campaign_id;
I'm wondering if there's a more efficient way, such as a function like $query->row(), to retrieve just the first row from the query result.

Alternatively, it would be even better if I could directly access the campaign_id from the query object itself, like $query->campaign_id, especially when there's only one row in the result set.

In addition, you can walk forward/backwards/first/last through your results using these variations:

PHP Code:

In addition, you can walk forward/backwards/first/last through your results using these variations:

$row = $query->first_row()
$row = $query->last_row()
$row = $query->next_row()
$row = $query->previous_row()
By default they return an object unless you put the word “array” in the parameter:

$row = $query->first_row(‘array’)
$row = $query->last_row(‘array’)
$row = $query->next_row(‘array’)
$row = $query->previous_row(‘array’) 


Generating Query Results

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

There's a couple of ways you can do this.

Using getRow():

PHP Code:

$query = $this->db->get()->getRow();
return $query->campaign_id; 


Using first():

PHP Code:

$query = $this->db->first();
return $query->campaign_id;