codeigniter get where return column value code example

Example 1: codeigniter get num_rows

// num rows example
$this->db->select('*');
$this->db->where('whatever');
$query = $this->db->get('table');
$num = $query->num_rows();

Example 2: get single column in codeigniter

$this->db->select('name');