Display related data from user profile

[eluser]doubleplusgood[/eluser]
Hi there,

My site gives users their own profile, with some URL routing, for example: www.mywebsite.com/profile/hanabi

I'm trying to grab information from other tables in the database, based on the user's id for the current profile (as above).

I have a profile_model that has the following function;

Code:

function get_single_profile($username)
        {
            $this->db->where('username', $username);
            $query = $this->db->get('users', 1);
            
            if ( $query->num_rows() == 1 )
            {
                return $query->row();
            }
            
            return FALSE;
        }

So as you can see, each user is stored in the users table with an id. What I would now like to do is get rows of data from another table (vehicles) where the user id matches that of the current profile.

I was wondering if anyone could tell me how I could accomplish this? I'm sure it would be much easier if i was passing the id in the profile function rather than the username, but this is needed for the URL routing. :S

Thank you for any help you might be able to pass on.