sunnysideup / silverstripe-geobrowser

            //2 check if continent exists

            $ContinentID = $row["ContinentID"];

            if ($continentPage = DataObject::get_one("BrowseContinentsPage", 'HiddenDataID = '.$ContinentID)) {

                //debug::show("continent exists");

            } else {

                //create continent

                $continents = $abstractHelpPage->getDataFromTable("continents", "ContinentID = ".$ContinentID, null);

                foreach ($continents as $continentData) {

                    $continentPage = new BrowseContinentsPage();

                    $continentPage->CreateContinent($continentData, $worldPage);

                }

            }

            //3 check if country exists

            $CountryID = $row["CountryID"];

            //3 check if country exists

            $CountryID = $row["CountryID"];

            if ($countryPage = DataObject::get_one("BrowseCountriesPage", 'HiddenDataID = '.$CountryID)) {

                //debug::show("country exists");

            } else {

                //create Country

                $countries = $abstractHelpPage->getDataFromTable("countries", "CountryID = ".$CountryID, null);

                foreach ($countries as $countryData) {

                    $countryPage = new BrowseCountriesPage();

                    $countryPage->CreateCountry($countryData, $continentPage);

                }

            }

            //4 check if region exists

            $RegionID = $row["RegionID"];

            //4 check if region exists

            $RegionID = $row["RegionID"];

            if ($regionPage = DataObject::get_one("BrowseRegionsPage", 'HiddenDataID = '.$RegionID)) {

                //debug::show("region exists");

            } else {

                //create region

                $regions = $abstractHelpPage->getDataFromTable("regions", "RegionID = ".$RegionID, null);

                foreach ($regions as $regionData) {

                    $regionPage = new BrowseRegionsPage();

                    $regionPage->CreateRegion($regionData, $countryPage);

                }

            }

            if ($cityPage = DataObject::get_one("BrowseCitiesPage", 'HiddenDataID = '.$CityID)) {

                //debug::show("city exists");

            } else {

                    $regionPage->CreateRegion($regionData, $countryPage);

                }

            }

            if ($cityPage = DataObject::get_one("BrowseCitiesPage", 'HiddenDataID = '.$CityID)) {

                //debug::show("city exists");

            } else {

                //create region

                $cities = $abstractHelpPage->getDataFromTable("cities", "CityID = ".$CityID, null);

                foreach ($cities as $city) {

                    $cityPage = new BrowseCitiesPage();

                    $cityPage->CreateCity($city, $regionPage);

                }

            }

        }

        return $cityPage;

    }