Connect with us

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.

4 Comments

4 Comments

  1. Pingback: Weekend Links - Jan 23, 2009 | OMNINOGGIN

You must be logged in to post a comment Login

Random Search Terms

Title

Top Articles

powered by WassUp

Recent Posts: Fully Net Worth . com

Alejandro Rosario Net Worth: How Rich is the Tik Tok star?

Alejandro Rosario Net Worth: How Rich is the Tik Tok star?

Alejandro Rosario is an up and coming Internet superstar who is famous for his activities on an app called Tik Tok. Within a couple of months, Rosario has been able to gain a huge following on his Tik Tok account. As of 2019, Alejandro Rosario net worth is estimated to be $100,000. Alejandro was born […]

Cyril Hanouna Net Worth: How Rich is the French TV Star?

Cyril Hanouna Net Worth: How Rich is the French TV Star?

Cyril Valéry Hanouna is a French radio and television presenter, writer, and producer. Hanouna is a polarizing figure who is best known for being the host of the popular French TV show Touche Pas à Mon Poste! As of 2019, Cyril Hanouna net worth is estimated to be $5 million. Hanouna was born on 23 […]

Donna Marie Lombardi Net Worth- How Rich is Black Ink Crew Star?

Donna Marie Lombardi Net Worth- How Rich is Black Ink Crew Star?

Taylor Monet Pinkney, who is better known as, Donna Marie Lombardi, is a tattoo artist and an influencer. She is best known for playing an important role in the reality television series called Black Ink Crew which airs in VH1. As of 2019, Donna Marie Lombardi net worth is estimated to be $350,000. Donna was […]