Database query issue, using WP user information... (2 posts)

  1. Jim R
    Posted 4 years 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
    Posted 4 years ago #

    Should I be using a While of If loop?

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.