I've posted this in the 'Themes and Templates' section, but nobody has answered, so I thought I'd try here instead.
What I'd like to do is fetch an array of all the unique values for a particular custom field, so that I can place them in a sidebar menu. I've been able to find documentation about Custom Fields, but it all seems to relate to fetching data on a per-post basis, 'inside the loop'. Is it a case of crafting custom MySQL queries to retrieve the necessary information, or can it be done using higher-level Wordpress functions?
Also, I'd like to be able to filter posts by the value of this custom field, so I can display matching posts on a page, in the same way I can display posts from a particular category.
Anyone any ideas?
a|x