Wordpress meta_value query not working

Question

Losing my mind. Long time customizer of Wordpress. THIS query has me baffled.

I have a record in wp_post meta where the following exist:

meta_id = 32765
post_id = 4376
meta_key = frontpage
meta_value = frontpage

the following query returns nothing:

if($events = $wpdb->get_results("SELECT post_id FROM wp_postmeta WHERE meta_value = 'frontpage';" )){
                    print_r($events);
}

What am I doing wrong?

have you enabled WP_DEBUG mode to see errors? Maybe some errors are being displayed? — Omar Tariq
Another check: Have you globalized $wpdb? like: global $wpdb;? — Omar Tariq
Not sure the problem is related, (not sure HOW it could be), but I get an error Trying to get property of non-object in E:\blahblahblah\wp-content\themes\Trailmeister\functions\taxonomies.php on line 81 — David McClave

Omar Tariq Omar Tariq · Accepted Answer · 2014-01-22T07:14:56

global $wpdb;
if($events = $wpdb->get_results("SELECT post_id FROM wp_postmeta WHERE meta_value = 'frontpage';" )){
                    print_r($events);
}

Wordpress meta_value query not working

2 Answers