Advertisement
Grork

Get meta values WP

Aug 31st, 2016
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.44 KB | None | 0 0
  1. function get_meta_values( $key, $type = 'post', $status = 'publish' ) {
  2.     global $wpdb;
  3.     if( empty( $key ) )
  4.         return;
  5.     $r = $wpdb->get_col( $wpdb->prepare( "
  6.        SELECT pm.meta_value FROM {$wpdb->postmeta} pm
  7.        LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id
  8.        WHERE pm.meta_key = '%s'
  9.        AND p.post_status = '%s'
  10.        AND p.post_type = '%s'
  11.    ", $key, $status, $type ) );
  12.  
  13.     return $r;
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement