Categories: Tips & Tricks

Pulling custom fields from outside the loop

In the last post “Creating a custom widget” I showed you how to create a custom widget. Well in this post I will show you how I used my custom widget to display all post with a certain custom field from outside the WordPress loop.

In the last post I used this tag:

<?php include(TEMPLATEPATH . '/includes/showcase.php'); ?>

Now I will show you what the file showcase.php has:

<ul>
<?php
global $wpdb;

$sql = "SELECT wposts.*
 FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
 WHERE wposts.ID = wpostmeta.post_id
 AND wpostmeta.meta_key = 'gallery-url'
 AND wposts.post_status = 'publish'
 AND wposts.post_type = 'post'
 ORDER BY wposts.post_date DESC LIMIT 8";

$pageposts = $wpdb->get_results($sql, OBJECT);
$output = $pre_HTML;

foreach ($pageposts as $post) : setup_postdata($post);  ?>

<li><a href="<?php echo get_post_meta($post->ID, "gallery-url", $single = true); ?>" title="Link to <?php the_title(); ?>">
<img src="<?php echo get_post_meta($post->ID, "image", $single = true); ?>" alt="<?php the_title(); ?>" /></a></li>

<?php endforeach; ?>

</ul>

That’s it! The most important item you may want to change for your own custom field is the line : AND wpostmeta.meta_key = 'gallery-url'. Where you would change the text in bold to match your own custom field value.

Update:

Check out Austin from PressedWords comment below.

With his great advise I was able to figure out why all my attempts to use the query_post weren’t working. it came down to this line of code: <?php echo get_post_meta($post->ID, "gallery-url", $single = true); ?>, that was what I had in my code, and the $post->ID is the reason my code would not echo or print the custom field’s value. Solution? replace $post->ID with get_the_ID(). HA, so simple.

Web Master

Hi, I am Miguel, I bought this site in 2009. So I now run or manage the site. Please visit my new website or follow me on twitter @W3i.

Recent Posts

5 Reasons You Should Never Give Up When Trying To Make Money From A Blog

Did you know that it's easier to increase your earnings each month from 2K to…

7 hours ago

Increase Your Chances Of Success By Using A Virtual Office.

The poor economic climate here in the UK has left many small businesses struggling to…

5 hours ago

Why And How SEO Services Are Extremely Beneficial.

When it comes to SEO services, there are a number of benefits that you’ll find…

17 hours ago

Six Advantages Of Cloud-Based Contract Management.

Cloud computing has revolutionized the way most companies manage and store data. However, many corporate…

1 day ago

Is An MBA In Marketing Worth It?

Different degrees come with different benefits. Some come with pay increase advantages, some come with…

2 days ago

The 6 Worst Things About Huge Colleges And Universities

For many people, one of the most important choices they will make during their lifetime…

2 days ago