1

I made a mysql query to WordPress like this:

$querystr = "
    SELECT $wpdb->posts.*
    FROM $wpdb->posts, $wpdb->postmeta
    WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
    AND $wpdb->postmeta.meta_key = 'where'
    AND $wpdb->postmeta.meta_value = 'london'
    LIMIT 0,50  ";

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

In this way i can grab all posts with meta_key = "where" and meta_value = london

The problem is that I've also got another meta_key, "date" and a meta_value that contains the real date like "05-06-2013", "06-06-2013", etc.

How can I query all posts with meta "where" = "london" and order by date using the data contain in meta "date" = "xx-xx-xxxx" ?

Improve this question

1 Answer 1

Reset to default
1

While the WPDB class, or its global $wpdb instance are your friend when it comes to querying custom tables or WP core data that does not have a higher-level API, it is overkill to use it to query posts.

Instead, read up on WP_Query.

In your case, you'd use it like so:

$args = array(
    'posts_per_page' => 50,    /* set limit to 50 */
    'post_type' => array( 'post', 'page' ), /* fetch both posts and pages */
    'meta_key' => 'date',    /* garb only posts with meta_key "date" set */
    'orderby' => 'meta_value_num',    /* sort by numeric value of above key */
    'order' => 'ASC', /* sot order */
    'meta_query' => array(    /* grab only posts/pages w/ "london" as value for "where" */
        array(
            'key' => 'where',
            'value' => 'london',
            'compare' => '='
        )
    )
);

$pageposts = new WP_Query( $args );

while ( $pageposts->have_posts() ) :
    $pageposts->the_post();
    /* output something */
endwhile;

wp_reset_postdata();

The above sorting by date will work flawlessly with either a timestamp or a YYYY-MM-DD string format.

With the way you currently have it, you will need an additional iteration...

Improve this answer
2
  • There are some differences between the MySQL query in the question and your solution. At first, the MySQL query limits the number of results to 50. -1 will return all results. And second, the MySQL query return all kind of posts (publish, trashed, draft, etc). Your solution returns only published posts/pages. Commented May 5, 2013 at 12:14
  • Set the limit to 50 now, obviously did not see that. But, @Ralf912, the latter point I assumed to be unwanted in the first place, given that the OP chose to call his variable holding the query results $pageposts... Commented May 5, 2013 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.