I have my own data table which is basically coach's name, his school and email. I manually keep that table up to date each year.
I'd like for my coaching Users when they sign in and go to their team's page, it shows their Team.
$query = "SELECT * FROM schools WHERE coachFirst = $current_user->user_firstname AND coachLast = $current_user->user_lastname";
I tried that first, and it didn't work. I'm pretty sure from there I need some sort of Join, but I don't know what I'm actually joining my 'schools' table to.