include ("by.php"); $apartment = $_GET['a']; $fetch = mysql_query("SELECT address,zipcode,city,country,type FROM apartments where id like '" . $apartment . "' LIMIT 1"); while ($apartment = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $buildingaddress=$apartment['address']." ".$apartment['zipcode']." ".$apartment['city']." ".$apartment['country']; $apartmenttype=$apartment['type']; } $fetch = mysql_query("SELECT type FROM types where id like '" . $apartmenttype . "' LIMIT 1"); while ($type = mysql_fetch_array($fetch, MYSQL_ASSOC)) { $buildingtype=$type['type']; } echo "Location of the ".$buildingtype.": ".$buildingaddress; ?>