Looping through left joined tables

[eluser]kgill[/eluser]
When you use joins in a one to many relationship you get repeating columns, that's the nature of a database and how it's supposed to work. You're one step away from the solution though, you're already comparing if the currentProjectID is not equal to the p_id, but you aren't storing the p_id in currentprojectid so each time it loops it's always true and will always print.