How to query custom post types with multiple keys?

Question

I recently upgraded WordPress from 3.0.x to 3.1.2. I had set it up to use custom post types before the upgrade. I need make a list of events that are occurring that started in the past until they occur.

For example, if an event started today at Noon, it should show up in this list until it ends, which could be tomorrow at 6:00 PM.

Can someone tell me how to modify this query so it will get custom posts that occur between the start and end date (multiple keys)?

$args = array ('post_type'      => 'events',
               'meta_key'       => 'end_date_value',
               'meta_compare'   => '>',
               'meta_value'     => $current_time,
               'orderby'        => 'meta_value',
               'order'          => 'ASC'
              );

Answer 1

Here is example from Codex on using BETWEEN with new format of meta query, which covers multiple fields as well:

$args = array(
    'post_type' => 'product',
    'meta_query' => array(
        array(
            'key' => 'color',
            'value' => 'blue',
            'compare' => 'NOT LIKE'
        ),
        array(
            'key' => 'price',
            'value' => array( 20, 100 ),
            'type' => 'numeric',
            'compare' => 'BETWEEN'
        )
    )
 );
$query = new WP_Query( $args );

See Custom Field Parameters for details.