Users and Multiple Categories

[eluser]Jondolar[/eluser]
Your result set would look something like this:
1 john smith plumbing
1 john smith roofing
2 tom brown roofing

Therefore, you need to modify your view to have an inner loop when the user_id is the same as the previous one (hint, save the user_id to a temp variable and then compare it on the next loop). Your inner loop will display the categories and the outer loop will display the name. The inner loop will only break when the user_id does not match the previous user id.