Why can't the returned object from CodeIgniter's row() method be printed with PHP's echo?
07:46 04 Mar 2013

I have code like this:

$this->db->select('title')->from('entries')->where('id', 1);
$query = $this->db->get();
echo $query->row('title');

Which echoes the title from the entries table where the id is equal to 1.

Why doesn't it work without the 'title in row function?

echo $query->row();

As it returns the first row?

Why do I have to have 'title' in both places ($query->row and $this->db->select), in order for this to work? It doesn't make sense to me.

Can anybody explain how this works, supposedly provide with alternative ways to get the value from the database?

php codeigniter codeigniter-2 resultset