I need some advice on how I can do this. I'm creating a network for local sites, and I need to be able to capture additional information on their location - specific State and Cities for US sites.
I want to be able to allow visitors to hit the main MU site and have a way to drill down to their local state and city, and then find all the sites that are active using something like the site directory. Ideally, when a user signs up for a site in ProSites, part of the registration will include choosing the state and city from drop down lists - where the state choice controls the cities then shown in the second field (hope that made sense).
This information then needs to be stored in the db so that I can query across the network to sort and filter display of sites based on these fields.
Does anything like this already exist? Or do I need to find a custom developer?
Thanks in advance.