Selecting one value from database?

[eluser]ELRafael[/eluser]

Code:

$tabela = 'usuarios';
$this->db->select('nome');  //Will find 'Rafael', my name
$this->b->where('cidade', 'São Bernardo do Campo'); //Where user in my city
$query = $this->get($tabela); // Get this f&#xck; name!

$nome = $this->db->row();
$nome = $nome->nome;

echo $nome //Produces Rafael

Capisce fancms?

It's a ugly example, but i hope you understand :-P