I have the following task to accomplish and don’t know where to start: I am working on a job offer website and I would like to list all cities where there are job openings in a sidebar widget/list. Like this:
We currently offer jobs in: Berlin, Munich, Potsdam, Stuttgart
I have the cities saved in every post that is a job offer so the date is there. What I need to do is query all published job posts, get the field with the city and list them. BUT I also need to list every city only once and don’t repeat them.
The best way to do this would be using a taxonomy for city instead of a text field.
Or you can query the database directly.
// replace city below with your meta key
$date = date('Y-m-d H:i:s');
$query = 'SELECT DISTINCT meta_value
FROM '.$wpdb->postmeta.' pm
WHERE pm.meta_key = "city"
ORDER BY pm.meta_value';
$values = $wpdb->get_results($query, 'ARRAY_A');