Php – WordPress: Get all values of a custom field

custom-fieldsPHPWordpress

I'm using Verve Meta Boxes. I want to make a menu out of one of the custom fields. How can I return all of the custom field values? For example, if I had a custom select field called "fruit" and as options I have "apples", "oranges", and "bananas", how could I get a complete list of those values, as an array perhaps? I can get the ones associated with a post:

get_post_custom_values('fruit')

…but I can't work out how to get the whole list.

Thank you in advance!

Best Answer

In case someone still wondering:

global $wpdb;
$results = $wpdb->get_results( 'SELECT DISTINCT meta_value FROM wp_postmeta WHERE meta_key LIKE "FIELD_NAME"', OBJECT );

Just make sure your postmeta table is "wp_postmeta" (default) and change FIELD_NAME with the name you created for the field in the admin.

Related Solutions

Php – How to get PHP errors to display

This always works for me:

ini_set('display_errors', '1');
ini_set('display_startup_errors', '1');
error_reporting(E_ALL);

However, this doesn't make PHP to show parse errors - the only way to show those errors is to modify your php.ini with this line:

display_errors = on

(if you don't have access to php.ini, then putting this line in .htaccess might work too):

php_flag display_errors 1

Php – thesql & php – query for record with all or fewer values, but not more

How about

SELECT * FROM box WHERE boxId NOT IN (
  SELECT * boxId FROM box WHERE fruit NOT IN ("apples", "oranges", "grapes"));

Best Answer

Related Solutions

Php – How to get PHP errors to display

Php – thesql & php – query for record with all or fewer values, but not more

Related Topic