Show a register database.

[eluser]guidorossi[/eluser]
I think you're looking for something like:

Code:

$this->db->select('name, age');
$this->db->where('gender', $gender);
$query = $this->db->get('peope');

if ($query->num_rows() > 0)
{
$queryresult = $query->result_array();


$name = $queryresults['0']['name']; //0 to get only the first or unique

}