mysql - wordpress查询2组元键

Question

我正在尝试执行自定义 SQL 查询来获取 2 个 post_meta 键和值。这是我的代码:

<?php
    $queried_post = get_post($post_id);
    $title = $term->name ;
    $userid =  $current_user->user_email;
    $result = mysql_query("SELECT * FROM wp_postmeta  WHERE meta_key='user_programme_name' AND meta_value='".$title."' AND meta_key='user_email' AND meta_value='".$userid."' ");
    $num_rows = mysql_num_rows($result);
    if ($num_rows > 0 ) {
?> 

<p style="width:430px;">You have already requested a place on this course</p>

<?php } ?>

当我查询第一组键和值时，查询的第一部分起作用:

meta_key='user_programme_name' AND meta_value='".$title."'

但是一旦我添加第二批:

AND meta_key='user_email' AND meta_value='".$userid."'

这不起作用。我是不是做错了什么？

任何帮助将不胜感激。

干杯，丹

Answer 1

使用这样的东西:

$args = array(  'post_type' => 'myposttype',
            'posts_per_page' => …,
            'offset' => …,
            'meta_query'=>array(    
                    'relation' => 'AND',
                    array(
                        'key'=>'_first_key',                    
                    'value'=> youvalue,
                    'type' => 'DATE', // etc.
                    'compare' => '='
                    ),
                    array(
                        'key'=>'_second_key',       
                                        'value'=> youvalue,
                    'type' => 'DATE', // etc.
                    'compare' => '='
                    )
            )
);
$yourloop  = new WP_Query( $args );