I have a Custom Field in my User Profile page that allows site authors to specify which town they come from when they set up their account. The towns are in the form of a selectable dropdown select element
What I would like to do is query the WP database to populate a dropdown of all the towns on the front end of my WP site and, when one town is selected, go to a page that lists all the authors who live in the town selected.
Is this possible? Any help greatly appreciated.