Selecting one value from database?

[eluser]xwero[/eluser]
[quote author="fancms" date="1193079984"]

Code:

$this->db->select('value'); #Because I need the value
$this->db->where('variable', 'siteoverview'); #Because I need the variable column entitled siteoverview
$grab_cache = $this->db->get("settings"); #From the settings table

[/quote]

You are on the right path but you have to go more specific

Code:

$this->db->select('value'); #Because I need the value
$this->db->where('variable', 'siteoverview'); #Because I need the variable column entitled siteoverview
$query = $this->db->get("settings"); #From the settings table
$row = $query->row; // get the row
echo $row->value

If you want to put it in a function

Code:

function scalar($table,$field,$where)
   $this->db->select($field); #Because I need the value
   $this->db->where($where); #Because I need the variable column    entitled siteoverview
   $query = $this->db->get($table); #From the settings table
   $row = $query->row_array(); // get the row
   return $row[$field]; // return the value
}