WordPress.org

Support

Support » Plugins and Hacks » Database query issue, using WP user information…

Database query issue, using WP user information…

  • 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.

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Database query issue, using WP user information…’ is closed to new replies.
Skip to toolbar