<?php /* * international_cities_spread.php * Spread out the 'international_cities' table records to their own tables in an 'international_cities' database. */ require '../inc.php'; $countryList = new Countries(); mysql_select_db($db, $dbconnect); $sqlCountries = "SELECT cc1 FROM international_cities GROUP BY cc1;"; $resultCountries = mysql_query($sqlCountries) or die('died trying to get countries out of the international_cities table of resellers_rrr: ' . mysql_error()); while ($cityCountries = mysql_fetch_assoc($resultCountries)) { $countryList->addCountry($cityCountries['cc1']); } echo "creating tables to store all the city information in<br />"; //createTables $countryList->createCountryTables(); echo "getting ready to fill the newly created tables <br />"; $countryList->fillTables(); class Countries { private $countries; private $server; // Your mySQL Server private $db_user; // Your mySQL Username private $db_pass; // Your mySQL Password private $db; // Database Name private $dbconnect;