"England",
"Mexico"=>"Mexico",
"New Zealand"=>"New Zealand",
"Italy"=>"Italy",
"Japan"=>"Japan",
"Switzerland"=>"Switzerland",
"France"=>"France",
"Singapore"=>"Singapore",
"Germany"=>"Germany",
"Bahamas"=>"Bahamas",
"Belgium"=>"Belgium",
"Finland"=>"Finland",
"Guatemala"=>"Guatemala",
"Bermuda"=>"Bermuda",
"Netherlands"=>"Netherlands",
"Philippines"=>"Philippines",
"United Kingdom"=>"United Kingdom",
"Australia"=>"Australia",
"ACT"=>"Australian Capital Territory",
"NSW"=>"New South Wales",
"NT"=>"Northern Territory",
"QLD"=>"Queensland",
"SA"=>"South Australia",
"TAS"=>"Tasmania",
"WA"=>"Western Australia",
"VIC"=>"Victoria",
"AB"=>"Alberta",
"BC"=>"British Columbia",
"MB"=>"Manitoba",
"NB"=>"New Brunswick",
"NF"=>"Newfoundland",
"NS"=>"Nova Scotia",
"NT"=>"Northwest Territories",
"NU"=>"Nunavut",
"ON"=>"Ontario",
"PEI"=>"Prince Edward Island",
"PQ"=>"Quebec",
"SK"=>"Saskatchewan",
"YT"=>"Yukon Territory",
"AK"=>"Alaska",
"AL"=>"Alabama",
"AR"=>"Arkansas",
"AS"=>"American Samoa (U.S. territory)",
"AZ"=>"Arizona",
"CA"=>"California",
"CO"=>"Colorado",
"CT"=>"Connecticut",
"DC"=>"District of Columbia",
"DE"=>"Delaware",
"FL"=>"Florida",
"FM"=>"Federal States of Micronesia (U.S. territory)",
"GA"=>"Georgia",
"GU"=>"Guam (U.S. territory)",
"HI"=>"Hawaii",
"IA"=>"Iowa",
"ID"=>"Idaho",
"IL"=>"Illinois",
"IN"=>"Indiana",
"KS"=>"Kansas",
"KY"=>"Kentucky",
"LA"=>"Louisiana",
"MA"=>"Massachusetts",
"MD"=>"Maryland",
"ME"=>"Maine",
"MH"=>"Marshall Islands (U.S. territory)",
"MI"=>"Michigan",
"MN"=>"Minnesota",
"MO"=>"Missouri",
"MP"=>"Northern Mariana Islands (U.S. territory)",
"MS"=>"Mississippi",
"MT"=>"Montana",
"NC"=>"North Carolina",
"ND"=>"North Dakota",
"NE"=>"Nebraska",
"NH"=>"New Hampshire",
"NJ"=>"New Jersey",
"NM"=>"New Mexico",
"NV"=>"Nevada",
"NY"=>"New York",
"OH"=>"Ohio",
"OK"=>"Oklahoma",
"OR"=>"Oregon",
"PA"=>"Pennsylvania",
"PR"=>"Puerto Rico (U.S. territory)",
"RI"=>"Rhode Island",
"SC"=>"South Carolina",
"SD"=>"South Dakota",
"TN"=>"Tennessee",
"TX"=>"Texas",
"UT"=>"Utah",
"VA"=>"Virginia",
"VI"=>"Virgin Islands (U.S. territory)",
"VT"=>"Vermont",
"WA"=>"Washington",
"WI"=>"Wisconsin",
"WV"=>"West Virginia",
"WY"=>"Wyoming",
"PI"=>"Prince Edward Island"
);
if($_GET['state']!='')
{
$instate=$_GET['state'];
if($states[$instate]!='')
{
$msg=sprintf('
Find a Neuromuscular Dentist in %s
', $states[$instate]);
$statequery=sprintf('SELECT * FROM contacts WHERE state="%s" or country="%s";',$instate,$instate);
$mysqlresult=mysql_query($statequery,$connection) or die(mysql_error());
if(mysql_num_rows($mysqlresult)==0) {$msg .='Currently there are no dentists registered with us in this area. Check with us again at a later date!
';}
else{
while($rows=mysql_fetch_row($mysqlresult)){
$contactresults[] = $rows;
}
shuffle($contactresults);
foreach($contactresults as $contactresult){
list($company, $contact,
$address1, $address2,
$city, $state, $zip,
$country,
$phone, $phone2, $fax,
$link, $email,
$city2, $state2, $id) = $contactresult;
$msg .='';
if($company!='') $msg.=sprintf('%s
',$company);
if($contact!='') $msg.=sprintf('%s
',$contact);
if($address1!='') $msg.=sprintf('%s
',$address1);
if($address2!='') $msg.=sprintf('%s
',$address2);
if($city!='') $msg.=sprintf('%s, ',$city);
if($state!='') $msg.=sprintf('%s ',$state);
if($zip!='') $msg.=sprintf('%s
',$zip);
if($country!='') $msg.=sprintf('%s
',$country);
if($phone!='') $msg.=sprintf('Phone: %s
',$phone);
if($phone2!='') $msg.=sprintf('Phone: %s
',$phone2);
if($fax!='') $msg.=sprintf('Fax: %s
',$fax);
if($link!=''||'') $msg.=sprintf('%s
',$link);
if($email!='') $msg.=sprintf('%s
',$email,$email);
if($city2!='') { $msg.=sprintf('%s',$city2); /*if($state2!='') {$msg.=', ';}*/}
if($state2 ='') $msg.="
";
if($state2!='') $msg.=sprintf(' %s
',$state2);
$msg .='
';
}
}
}
else{ $msg='No State Specified'; }
}
else{ $msg='No State Specified'; }
require_once("template.php");
//echo $msg;
//echo '';
//echo $states[$instate];
//echo '
';
//echo $_GET['state'];
//echo '
';
?>