I'm trying to create some PHP to use in a plaintext widget that'll display information in my sidebar. Because some of the information will be identical across some of the parts of the site instead of storing the information in custom fields I'm trying to store it in a MYSQL table. What I'd like the code to do is to identify the post taxonomy, lookup the id field in my table, find the row with that shares the id with the taxonomy and then echo the values of other fields on that row.

I have my taxonomy setup as well as my table but I can't find much of a precedent for this and therefore I'm struggling to know where to start.

So far I'm trying to call the current post taxonomy's value but I can't get it to work outside the loop

<?php
$current_tax = get_query_var('game');
echo $current_tax;
?>

Update: I'm now trying to find a way to echo the metadata of a custom taxonomy's value.

I'm trying to create some PHP to use in a plaintext widget that'll display information in my sidebar. Because some of the information will be identical across some of the parts of the site instead of storing the information in custom fields I'm trying to store it in a MYSQL table. What I'd like the code to do is to identify the post taxonomy, lookup the id field in my table, find the row with that shares the id with the taxonomy and then echo the values of other fields on that row.

I have my taxonomy setup as well as my table but I can't find much of a precedent for this and therefore I'm struggling to know where to start.

So far I'm trying to call the current post taxonomy's value but I can't get it to work outside the loop

<?php
$current_tax = get_query_var('game');
echo $current_tax;
?>

I'm trying to create some PHP to use in a plaintext widget that'll display information in my sidebar. Because some of the information will be identical across some of the parts of the site instead of storing the information in custom fields I'm trying to store it in a MYSQL table. What I'd like the code to do is to identify the post taxonomy, lookup the id field in my table, find the row with that shares the id with the taxonomy and then echo the values of other fields on that row.

I have my taxonomy setup as well as my table but I can't find much of a precedent for this and therefore I'm struggling to know where to start.

I'm trying to create some PHP to use in a plaintext widget that'll display information in my sidebar. Because some of the information will be identical across some of the parts of the site instead of storing the information in custom fields I'm trying to store it in a MYSQL table. What I'd like the code to do is to identify the post taxonomy, lookup the id field in my table, find the row with that shares the id with the taxonomy and then echo the values of other fields on that row.

I have my taxonomy setup as well as my table but I can't find much of a precedent for this and therefore I'm struggling to know where to start.

So far I'm trying to call the current post taxonomy's value but I can't get it to work outside the loop

<?php
$current_tax = get_query_var('game');
echo $current_tax;
?>