WordPress.org

1. Jim R
   Member
   Posted 9 months ago #

   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.

2. Jim R
   Member
   Posted 9 months ago #

   Should I be using a While of If loop?

Reply

You must log in to post.