Call to a member function row() on a non-object

[eluser]Aken[/eluser]
You've got a lot of unnecessary logic going on. You're using one query to retrieve all of the IDs, and then you're looping through them and doing individual queries to get each row. Pretty redundant, considering you can retrieve all of that data just doing one normal query.

Code:

$query = $this->db
->query("SELECT fb_id, total_page_like, talking_about_count, were_here_count FROM fb_page_profile")
->result();

// result() returns an array of objects, each object is a row in the DB.

foreach ($query as $row)
{
$score = $row->total_page_like + $row->talking_about_count + $row->were_here_count;
}