Sometimes you only want to show posts that you’ve added a specific custom field to. For instance, lets say you write book and movie reviews and for each you give them a custom field “review_type” with the value set to either “book” or “movie”. So how would you show posts that are only movie reviews? Easily!
A typical post loop begins like this:
<?php if (have_posts()) : ?> <?php while (have_posts()) : the_post(); ?>
We’re going to add a simple query_posts function immediately above the loop code. In our scenario it would look like this:
<?php query_posts('meta_key=review_type&meta_value=movie'); ?>
<?php if (have_posts()) : ?>
<?php while (have_posts()) : the_post(); ?>
We’ve now restricted posts in the loop to movie reviews. Easy! Read the WP Codex article for more advanced uses of the query_posts function.
Tomas Buteler
May 6, 20093:30 amJust followed here from Wp-Recipes…
This is a great function, thanks for sharing!
Just a heads-up, though, which you can correct me if I’m wrong: I tried to use it a while back and found out that it wasn’t good for the type of Custom Field I had created (I figured instead of doing ‘yes’ or ‘no’ meta values for my fields, I use the classic binary ‘0′ and ‘1′), only to find out that calling ‘meta_key=whatever&meta_value=0′ completely ignores the second parameter…
If you need to fetch custom fields whose value needs to be ‘0′, you’ll have to use a Custom SELECT query, instead.
Cheers!
Jerry
July 23, 200911:29 amJohn,
I’ve tested this code and it works great … however I would like to be able to sort the order of the posts as they appear on the page … i have a meta_key called “player-jersey-number” that I would like to sort the entries as they are displayed by the player’s number, not when post created.
justgage
August 26, 20093:32 pmThink you just saved my bacon =D
pete
October 2, 20092:03 pmHi John… almost what i was looking for. How would would this be updated if I only want to show posts that I’ve added 2 or 3 specific custom fields to
thanks
Pete
Jennifer R
July 13, 20102:50 pmThanks, your code help me alot
Jeremy Johnson
September 3, 20106:36 pmThanks for the helpful heads up. I combined the “meta_key=review_type&meta_value=movie” with some other coding to create a dual sidebar listing for products for a website that I am working on.
Alvin19
September 8, 20106:08 amthank you for your wise and helpful tutorial
Ted
October 13, 20106:31 amhow to had pagination, thx
curdaneta
September 9, 20114:40 pmHello John
It’s possible to get the value of the custom field instead of write inside “query_posts”
Regards
Ciro
Discount Social UK
September 23, 201111:39 amI have used this in order to display either vouchers or offers or both on my site. It works great. Thanks for you time and effort putting this together.