include_once("config.php"); $states= array( "England"=>"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
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 .='
'; //echo $states[$instate]; //echo '
'; //echo $_GET['state']; //echo '
'; ?>