<?php
// STICK THIS IN YOUR PIPE AND SMOKE IT

// OPEN DATA BASE
define("HOSTNAME","localhost");
define("USERNAME","USERNAME HERE");
define("PASSWORD","PASSWORD HERE");
define("DATABASE","DB NAME HERE");
mysql_connect(HOSTNAME, USERNAME, PASSWORD) or die("Connetion to database failed!");
mysql_select_db(DATABASE);

// CREATE TABLES
mysql_query("CREATE TABLE que_countries ( id int(3) NOT NULL ,".
"country varchar(100) NOT NULL ,".
"UNIQUE KEY id (id))");
mysql_query("CREATE TABLE que_states ( id int(3) NOT NULL ,".
"states varchar(100) NOT NULL ,".
"UNIQUE KEY id (id))");

// LIST OF ALL COUNTRIES IN THE WORLD!
$countries = "Afghanistan,Albania,Algeria,Andorra,Angola,Antigua &amp; Deps,Argentina,Armenia,Australia,Austria,Azerbaijan,Bahamas,Bahrain,Bangladesh,Barbados,Belarus,Belgium,Belize,Benin,Bhutan,Bolivia,Bosnia Herzegovina,Botswana,Brazil,Brunei,Bulgaria,Burkina,Burundi,Cambodia,Cameroon,Canada,Cape Verde,Central African Rep,Chad,Chile,China,Colombia,Comoros,Congo,Congo {Democratic Rep},Costa Rica,Croatia,Cuba,Cyprus,Czech Republic,Denmark,Djibouti,Dominica,Dominican Republic,East Timor,Ecuador,Egypt,El Salvador,Equatorial Guinea,Eritrea,Estonia,Ethiopia,Fiji,Finland,France,Gabon,Gambia,Georgia,Germany,Ghana,Greece,Grenada,Guatemala,Guinea,Guinea-Bissau,Guyana,Haiti,Honduras,Hungary,Iceland,India,Indonesia,Iran,Iraq,Ireland {Republic},Israel,Italy,Ivory Coast,Jamaica,Japan,Jordan,Kazakhstan,Kenya,Kiribati,Korea North,Korea South,Kosovo,Kuwait,Kyrgyzstan,Laos,Latvia,Lebanon,Lesotho,Liberia,Libya,Liechtenstein,Lithuania,Luxembourg,Macedonia,Madagascar,Malawi,Malaysia,Maldives,Mali,Malta,Marshall Islands,Mauritania,Mauritius,Mexico,Micronesia,Moldova,Monaco,Mongolia,Montenegro,Morocco,Mozambique,Myanmar, {Burma},Namibia,Nauru,Nepal,Netherlands,New Zealand,Nicaragua,Niger,Nigeria,Norway,Oman,Pakistan,Palau,Panama,Papua New Guinea,Paraguay,Peru,Philippines,Poland,Portugal,Qatar,Romania,Russian Federation,Rwanda,St Kitts &amp; Nevis,St Lucia,Saint Vincent &amp; the Grenadines,Samoa,San Marino,Sao Tome &amp; Principe,Saudi Arabia,Senegal,Serbia,Seychelles,Sierra Leone,Singapore,Slovakia,Slovenia,Solomon Islands,Somalia,South Africa,Spain,Sri Lanka,Sudan,Suriname,Swaziland,Sweden,Switzerland,Syria,Taiwan,Tajikistan,Tanzania,Thailand,Togo,Tonga,Trinidad &amp; Tobago,Tunisia,Turkey,Turkmenistan,Tuvalu,Uganda,Ukraine,United Arab Emirates,United Kingdom,United States,Uruguay,Uzbekistan,Vanuatu,Vatican City,Venezuela,Vietnam,Yemen,Zambia,Zimbabwe";

// List of All USA States
$states = "Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio,Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming";

// OH NOEZ ITS BUSH!
$GWBush = explode(",", $countries);
$GWBush_state = explode(",", $states);
?>
<table width="500" border="0" cellpadding="0" cellspacing="0">
<?php
//Start from 1
$i = 1;
foreach($GWBush as $ce){

//Countries & States
$query = mysql_query("INSERT INTO que_countries VALUES('{$i}', '{$ce}' )");
?>
<tr>
<td width="59" align="right"><div style="padding:4px;"><?= $i ?>. )</div></td>
<td width="441" align="left"><div style="padding:4px;"><?= $ce ?>&nbsp;&nbsp;<?php
if (!$query) {
echo '<span style="font-weight:bold; color:#FF0000;">( Failed )';
}
else {
echo '<span style="font-weight:bold; color:#00FF00;">( GTG! )';
}
?></span></div></td>
</tr>
<?php $i++;
}
?>
</table>
<table width="500" border="0" cellpadding="0" cellspacing="0">
<?php
// Start from 1
$i = 1;
foreach($GWBush_state as $ce){

// Countries & States
$query = mysql_query("INSERT INTO que_states VALUES('{$i}', '{$ce}' )");
?>
<tr>
<td width="59" align="right"><div style="padding:4px;"><?= $i ?>. )</div></td>
<td width="441" align="left"><div style="padding:4px;"><?= $ce ?>&nbsp;&nbsp;<?php
if (!$query) {
echo '<span style="font-weight:bold; color:#FF0000;">( Failed )';
}
else {
echo '<span style="font-weight:bold; color:#00FF00;">( GTG! )';
}
?></span></div></td>
</tr>
<?php $i++;
}
?>
</table>