Let join issue

[JamesB]

Hey

 

I can't seem to get this left join to work to retrieve the username from the users table.

 

projects.external_project_user can be 0, with no users.user_id being 0.

 

 

SELECTprojects.*,users.username AS external_project_username,(SELECT COUNT(*) FROM todo_entries WHERE todo_entries.project_id = projects.project_id AND status = 1) AS entry_count_open,(SELECT COUNT(*) FROM todo_entries WHERE todo_entries.project_id = projects.project_id AND status = 2) AS entry_count_pending_testing,(SELECT COUNT(*) FROM todo_entries WHERE todo_entries.project_id = projects.project_id AND status = 3) AS entry_count_resolved,(SELECT COUNT(*) FROM todo_entries WHERE todo_entries.project_id = projects.project_id AND status = 4) AS entry_count_skippedFROM projectsLEFT JOIN usersON users.user_id = projects.external_project_userWHERE projects.todo_listed = 1ORDER BY `order` DESC

[justsomeguy]

What happens when you run that?

[JamesB]

 

This project tracker is hosted here for <?php htmlspecialchars($project->external_project_username); ?>.

 

So the query was fine, turns out I'd forgotten the word echo lol.