'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

'; echo 'Abandoned Buildings of '.$townName.''; echo '
'; echo "These are the buildings of ".$townName." that have been abandoned or closed down."; echo '

'; echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $result = getRows(places,"WHERE town='$town' and abandoned!=''"); while ($row = mysql_fetch_array($result)) { $id = $row['id']; $name = stripslashes($row['name']); echo ''; echo ''; $owner = $row['owner']; $owner = getInfo(username,users,"WHERE id='$owner'"); echo ''; echo ''; echo ''; echo ''; } echo ''; echo '

'; echo 'Building'; echo '	'; echo 'Owner'; echo '	'; echo 'Type'; echo '	'; echo 'Rooms'; echo '
'; $max2 = numRows(rooms); $counter = numRowsConditions(rooms,"WHERE place='$id'"); if ($counter == 1) { $conditions = "WHERE place='$id'"; $room = getInfo(id,rooms,$conditions); echo ''.$name.''; } else echo ''.$name.''; echo '	'; echo $owner; echo '	'; $type = $row['type']; $type = getInfo(type,buildings,"WHERE id='$type'"); $type[0] = strtoupper($type[0]); echo $type; echo '	'; echo $counter; echo '

'; echo ''; } else { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

'; echo 'Error'; echo '
'; echo 'This town does not exist.'; echo '

'; echo ''; } ?>