Home Forums Front-end Issues Make a list of cities from custom fields


Make a list of cities from custom fields

  • Hello,

    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.

    Can anyone help me getting this done right?

    Thank you and regards,

  • 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
    global $wpdb;
    $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');

    See documentation for $wpdb here

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Cookie Policy. If you continue to use this site, you consent to our use of cookies.