$geocountry / $location";
} elseif($location_type == "city"){
$location = addslashes($location);
$query2 = "SELECT `admin1`, `admin2`, `country` FROM `geoname2` WHERE `asciiname` LIKE '$location'";
$result = mysql_query($query2);
while($row = mysql_fetch_row($result))
{
$geocomunity = $row[0];
$geoprovince = $row[1];
$geocountry = $row[2];
}
$location = stripslashes($location);
$locationlower = $location;
$locationlower = strtolower($locationlower);
$geoprovincelower = $geoprovince;
$geoprovincelower = strtolower($geoprovincelower);
$geocountrylower = $geocountry;
$geocountrylower = strtolower($geocountrylower);
echo "$location /
$geoprovince / $geocomunity /
$geocountry";
} elseif($location_type == "country"){
$location = addslashes($location);
$query2 = "SELECT `admin1`, `admin2`, `country` FROM `geoname2` WHERE `asciiname` LIKE '$location'";
$result = mysqli_query($query2);
while($row = mysql_fetch_row($result))
{
$geocomunity = $row[0];
$geoprovince = $row[1];
}
$location = stripslashes($location);
echo "
Top / $location";
} else {
echo "";
}
?>