* 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;
function __construct()
{
$this->countries = array();
