antonozolin

Hello, friends. I have tried to use one of codes from your discussing, and I have a problem with it.

I do not understand, does this code should work correct?

function my_query_posts($q=''){
  add_filter('posts_where', 'my_posts_where');
  add_filter('posts_join', 'my_posts_join');
  query_posts($q);
  remove_filter('posts_where', 'my_posts_where');
  remove_filter('posts_join', 'my_posts_join');
}

 function my_posts_where($where){
 global $wpdb;
 return $where . "
 AND $wpdb->postmeta.meta_key = 'test1'
 AND $wpdb->postmeta.meta_value = 'value1' 

 AND $wpdb->postmeta.meta_key = 'test2'
 AND $wpdb->postmeta.meta_value = 'value2' 

 AND $wpdb->postmeta.meta_key = 'test3'
 AND $wpdb->postmeta.meta_value = 'value3' "; } 

function my_posts_join($join){
  global $wpdb;
  return $join . " JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) ";
}

I am asking, because it does not show anything, dispite of I have a post with theese fields and values.

but I want to add, that filter

function my_posts_where($where){
 global $wpdb;
 return $where . "
 AND $wpdb->postmeta.meta_key = 'test1'
 AND $wpdb->postmeta.meta_value = 'value1'
 "; }

Works fine. Please, can you wright me (in english) – did you solve this problem, and right the correct code. 感謝 =)

Now my code is like this, works fine, but not quate accurate, I need to compare 2 meta_keys

function filter_where($where = '') {
	$date_start = ('30.03.2010');
	$date_end = ('30.04.2012');

    $where .= '
	AND STR_TO_DATE(meta_value,"%d.%m.%Y") >= STR_TO_DATE("'.$date_start.'","%d.%m.%Y")
	AND STR_TO_DATE(meta_value,"%d.%m.%Y") <= STR_TO_DATE("'.$date_end.'","%d.%m.%Y")
	';
    return $where;
}

function date_order($orderby = '') {
    $order .= 'STR_TO_DATE(meta_value,"%d.%m.%Y") ASC';
    return $order;
}

add_filter('posts_where', 'filter_where');
add_filter('posts_orderby', 'date_order');

$args = array(
	'category__and' => array($child_cat_id,$child_cat_id),
	'meta_key' => $meta_field_name,
	'showposts' => -1,
	);

$my_query = new WP_Query($args);

remove_filter('posts_where', 'filter_where');
remove_filter('posts_orderby', 'date_order');

Just in case =)