Display related data from user profile

[eluser]mddd[/eluser]
Yes, looks right to me. You could put the 'where' clause in the 'join' but I don't think that makes much difference in the end.

Code:

// this:
$this->db->join('vehicles', 'vehicles.userId = users.id', 'left');
$this->db->where('vehicles', 'vehicles.featured = 1');
// can be written as:
$this->db->join('vehicles', 'vehicles.userId = users.id AND vehicles.featured=1', 'left');

But remember: if a user has more than 1 vehicle, you will get more than 1 row from this query!
So your check 'if num_rows is 1' is no longer right. You should just check if there are any rows found.
The result might look like this:

Code:

For a person with one vehicle:

users.id   users.username   vehicles.userId   vehicles.featured   vehicles.name
-------------------------------------------------------------------------------
1          mike             1                 1                   vehicleX


For a person with 3 vehicles:

users.id   users.username   vehicles.userId   vehicles.featured   vehicles.name
-------------------------------------------------------------------------------
2          pete             2                 1                   vehicleX
2          pete             2                 1                   vehicleY
2          pete             2                 1                   vehicleZ


For a person with 0 vehicles:

users.id   users.username   vehicles.userId   vehicles.featured   vehicles.name
-------------------------------------------------------------------------------
3          chris            null              null                null