Update dbinterface.php
Update dbinterface.php

Moved the RoleID <> 6 into the left join condition for nra_roles.  Since most coaches or managers have multiple roles per team (ex. Parent and Head Coach) this new SQL change will make the roleName NULL when it is Parent.  Now I added the Order by clause with the minus sign in front of RoleName and I set the sorting to descending.

In MySQL this sorts NULLS last.  Now the right role will be selected allowing coaches or managers to be able to add, edit events, locations, teams.
brucekeats/nra