Display related data from user profile

[eluser]doubleplusgood[/eluser]
Thanks man. I've just quickly put together this query;

Code:

public function getFeaturedVehiclesByUser(){
            $this->db->select('users.*, vehicles.*');
            $this->db->where('users.username', $username);
            $this->db->from('users');
            $this->db->join('vehicles', 'vehicles.userId = users.id', 'left');
            $this->db->where('vehicles', 'vehicles.featured = 1')
            $this->db->get();

            if ( $query->num_rows() == 1 )
            {
                return $query->row();
            }

            return FALSE;
        }

This should (in theory) find all vehicles where the userId of the profile being viewed matches and also where rows in the vehicles table are marked as featured. Hopefully this looks about right.