wordpress custom query with meta data

Question

I am trying to get the latest post with a meta value of headline, but it gives me the latest post made instead. Here is my query, what am i doing wrong?

$querydetails = "
        SELECT $wpdb->posts.* 
        FROM $wpdb->posts, $wpdb->postmeta
        WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id  
        AND $wpdb->postmeta.meta_value = 'headline'
        AND $wpdb->postmeta.meta_key = 'custom_select'
        AND $wpdb->posts.post_status = 'publish'
        AND $wpdb->posts.post_type = 'post'
        ORDER BY $wpdb->posts.post_date DESC
        LIMIT 1
    ";

    $headline = $wpdb->get_results($querydetails, OBJECT);

janw · Accepted Answer · 2012-04-16 09:51:32Z

1

You should do it in wp_query,
The code below should do it.

<?php
$args = array(
    'post_type' => 'post',
    'post_status' => 'publish',
    'meta_key' => 'custom_select',
    'meta_value' => 'headline',
    'posts_per_page' => '1', //limit
    'paged' => get_query_var( 'page' ),
    'order' => 'DESC',
    'orderby' => 'date'
);
$query = new WP_Query($args);
?>

This way you can use the default wordpress tags like the_content() in a loop

answered Apr 16, 2012 at 9:51

janw

6,6726 gold badges29 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

looneydoodle Over a year ago

Thanks! that worked! What is wrong with the way i was doing it?

janw Over a year ago

I'm not sure, but you can check the query WP_query made with echo $query->request

Collectives™ on Stack Overflow

wordpress custom query with meta data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related