Text Widget to Show database fields based on post

Question

I am wondering whether this is possible:

• I would like a widget which displays fields taken from a database table I have created.

Table contains information about the location of the post.

Widget to show the information about the post location based on a custom field in the post e.g

Post Custom Field Location = London

Widget to show text about London (stored in the database)

Answer 1

I can't find a plugin that does this, but here's an alternative:

You can use code like this to get the post's metadata (custom field) values in the widget sidebar.php:

<?php global $post; ?>
<?php $sidebar = get_post_meta($post->ID, 'sidebarval', $single = true); ?>
<?php if($sidebar != '') { ?>
    <?php $myrows = $wpdb->get_results( "SELECT id, name FROM mytable WHERE col = " . $sidebar );
<?php } ?>