Join Logic

[eluser]weboap[/eluser]
looks to me like you will be doing like

Code:

public function get_events($user_id)
{
  $query = $this->db->select('users_colleges.*', FALSE)
               ->select('events.*', FALSE)
                ->join('events', 'events.college_id = users_colleges.college_id' )
                ->where('users_colleges.user_id', $user_id)
                ->get('users_colleges');

  if ($query->num_rows() > 0) return $query->result_array();

  return FALSE;
}

change events.user_id to events.author_id