Question

我正试图获得最新职位,其价值是头盔,但给我以最新的职位。我在此问,什么是错的?

$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);

Answer 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);
?>

这样,你就可以在上使用默认字标。

友情链接