I have a database that consists of zipcode, city, state and population. I need the code to pull data from city + state, and state to display population; I can currently pull zipcode data, but need help with coding past that. Right now the script runs and pulls back the zipcode that you enter through a URL (mysite.com/page.php&zipcode=90210) and displays the population for that zipcode, as well as the city and state name. However, some citys have multiple zipcodes and the population is set at the zipcode level, I can't figure out how to do the proper coding and math to sum up all the populations, PLUS some cities exist in multiple states, i.e. Springfield. So I need something set up that when I use this URL mysite.com/page.php&city=Beverly Hills&st=CA it will sum up all the populations for the zipcodes associated with Beverly Hills in the state California (CA). As well, I need it done for the state level so when I go to mysite.com/page.php&state=CA it will sum up the population for every zipcode in CA. Im guessing the best idea would be to have a caching system in place, any suggestions to doing that? PM me if your interested