I have a request where I want to use a conditional statement which checks if the user's team is playing home or away for that week, this data is stored in a custom database in WordPress, and then display a form according to the result.
For example: team a is playing home this week, so the result would show the users team name and and display the status of the game to be either home or away (based on which date the query was ran) this would then re-direct the user to the correct form to choose their players for that game.
I believe a hook and filter is required to perform this function? But how do I query the database, I have seen similar queries for WP posts but not for a custom database table?
My problem is that little knowledge of PHP, hence have used conditional logic using check boxes for the time being.