Error when getting value from query

[eluser]bondjp[/eluser]
Hi, i'm getting an error when trying to display some info i have from a query.
The error is this: Trying to get property of non-object
I've spent several hours on this but i can't see where i'm wrong.

Print_r shows something like this:
Array ( [0] => stdClass Object ( [id] => 10 [user_id] => 10 [username] => James ))

Model

Code:

$query = $this->db->get('user_profiles');
$usr=$query->result();
foreach($usr as $row){
    $users[]=$row;
}
return $users;

View

Code:

<?php foreach($results as $row):
    $username=$results->username;
?>

[eluser]n0xie[/eluser]

Code:

// Model
$query = $this->db->get('user_profiles');
if ($query->num_rows() >0)
{
  return $query->result();
}
else
{
  return FALSE;
}

// View
foreach ($results as $row):
  echo $row->username;
endforeach;

[eluser]packetfox[/eluser]
You could do:

Code:

$query=$this->db->get('user_profiles');
$results = $query->result_array();
foreach($results as $result){
print "$result[username]<br />";
}

[eluser]bondjp[/eluser]
[quote author="n0xie" date="1276101453"]

Code:

// Model
$query = $this->db->get('user_profiles');
if ($query->num_rows() >0)
{
  return $query->result();
}
else
{
  return FALSE;
}

// View
foreach ($results as $row):
  echo $row->username;
endforeach;

[/quote]


That did it.
Thanks.