Get Field Values From WordPress Query

Question

I used the following code to run a wordpress query... //using the $thePost[ID], get the fees associated with this accommodation from within the post_meta table.

$post_meta_querystr = "
SELECT *
FROM $wpdb->postsmeta
WHERE $wpdb->postsmeta.post_id = '$thePost[ID]'
";

$customPostMeta = $wpdb->get_results($post_meta_querystr);

The table has fields called "meta_key" and "meta_value". I'd like to know how I can use the value of any row in "meta_key" to get its corresponding value from the "meta_value" field? Any help is greatly appreciated.

Mauro · Accepted Answer · 2014-10-08 17:55:47Z

1

why don't you use the get_post_meta function?

answered Oct 8, 2014 at 17:55

Mauro

1,48112 silver badges22 bronze badges

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

1 Comment

Alex Williams Over a year ago

Ah ha!... I had forgotten about this function. Thank you sir for preventing me from reinventing the wheel :)

Collectives™ on Stack Overflow

Get Field Values From WordPress Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related