Query posts based on custom field in wordpress

Question

Im trying to write a query that will find and display all of my posts that have the same custom field values as my input.

In wordpress I have the following...

enter image description here

My query is...

$pageposts = $wpdb->get_results("SELECT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_value = 'petrol' OR wpostmeta.meta_value = 'local' ORDER BY wpostmeta.meta_value DESC", OBJECT);

If I remove 'OR wpostmeta.meta_value = 'local' This works correctly and pulls the correct post with the custom field value as 'petrol'

Can anybody give me an idea on where im going wrong? At the moment its display all of my posts even those that are drafts and have been deleted and its also looping and displaying them numerous times...

Sudhir Bastakoti · Accepted Answer · 2012-03-21 10:04:00Z

1

Try:


SELECT wposts.* 
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta 
WHERE wposts.ID = wpostmeta.post_id 
AND (wpostmeta.meta_value = 'petrol' OR wpostmeta.meta_value = 'local') 
ORDER BY wpostmeta.meta_value DESC"

answered Mar 21, 2012 at 10:04

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Liam Over a year ago

Wow that's actually worked! only problem is its pulling the results through more than once, as though its looping for some...

Sudhir Bastakoti Over a year ago

you can add GROUP BY post_id and see the result, did you mean something like that...

Liam · Accepted Answer · 2012-03-21 10:27:01Z

0

Figured it out...

<?php
$customkey = 'Network'; // set to your custom key
$customvalue = 'Local'; // set to custom value

global $wpdb;
$my_posts = $wpdb->get_results("SELECT * FROM $wpdb->posts, $wpdb->postmeta WHERE ID = $wpdb->postmeta.post_id AND meta_key = '$customkey' AND meta_value = '$customvalue' ORDER BY post_date DESC");

foreach ($my_posts as $post) :
setup_postdata($post);

echo '<div><a href="';
the_permalink();
echo '"></div>';
the_title();

endforeach;
?>

answered Mar 21, 2012 at 10:27

Liam

9,88340 gold badges116 silver badges214 bronze badges

Collectives™ on Stack Overflow

Query posts based on custom field in wordpress

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related