如果自定义字段为 true，则显示最新帖子

Question

我试图让 WordPress 仅在使用自定义字段满足三个条件时才发布最新帖子。首先，河流必须是“Colorado”，区域必须是“Area 4”，位置必须是“soundbite 5”。这可能吗？

到目前为止的代码：

<?php $querystr = "
      SELECT wposts.*
      FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
      WHERE wposts.ID = wpostmeta.post_id
      AND wpostmeta.meta_key = 'select_river'
      AND wpostmeta.meta_value = 'Colorado'
      AND wpostmeta.meta_key = 'select_area'
      AND wpostmeta.meta_value = 'Area 4'
      AND wpostmeta.meta_key = 'select_soundbite_position'
      AND wpostmeta.meta_value = 'soundbite 5'
      AND wposts.post_status = 'publish'
      AND wposts.post_type = 'post'
      ORDER BY wposts.post_date DESC
      ";

     $pageposts = $wpdb->get_results($querystr, OBJECT);

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

        <p>Test</p>

        <?php endforeach; ?>
    <?php endif; ?>

它不起作用，我不知道为什么......我对 PHP 的理解缺乏

Answer 1

那又怎么样：

<?php
$querystr = "
      SELECT wposts.*
      FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta, $wpdb->postmeta wpostmeta2, $wpdb->postmeta wpostmeta3
      WHERE wposts.ID = wpostmeta.post_id
      AND wpostmeta.meta_key = 'select_river'
      AND wpostmeta.meta_value = 'Colorado'
      AND wpostmeta2.meta_key = 'select_area'
      AND wpostmeta2.meta_value = 'Area 4'
      AND wpostmeta3.meta_key = 'select_soundbite_position'
      AND wpostmeta3.meta_value = 'soundbite 5'
      AND wposts.post_status = 'publish'
      AND wposts.post_type = 'post'
      ORDER BY wposts.post_date DESC
      ";
?>