<?php require_once('Connections/conn_newland.php'); ?>
<?php
$colname_rs_countries = "-1";
if (isset($_GET['countryID'])) {
  $colname_rs_countries = (get_magic_quotes_gpc()) ? $_GET['countryID'] : addslashes($_GET['countryID']);
}
mysql_select_db($database_conn_newland, $conn_newland);
$query_rs_countries = sprintf("SELECT * FROM tbl_country, tbl_region WHERE tbl_region.regionID = tbl_country.region AND countryID = %s", $colname_rs_countries);
$rs_countries = mysql_query($query_rs_countries, $conn_newland) or die(mysql_error());
$row_rs_countries = mysql_fetch_assoc($rs_countries);
$totalRows_rs_countries = mysql_num_rows($rs_countries);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Newland Tours: Opis Kraju</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
<link href="css/newland.css" rel="stylesheet" type="text/css" />
</head>

<body>
<a href="#top"><img src="images/spacer.gif" alt="Skip to main page content" width="1" height="1" border="0" align="left" /></a>
<table width="750" border="0" cellpadding="3" cellspacing="0">
 <tr>
  <td><img src="images/banner_left.gif" width="451" height="68" alt="Newland Tours Banner, Left." /></td>
  <td width="280"><img src="images/banner_right.jpg" width="276" height="68" alt="Newland Tour Banner, Right." /></td>
 </tr>
 <tr>
  <td><img src="images/navbar.gif" name="navbar" width="450" height="20" border="0" usemap="#navbarMap" alt="Navigation Bar." /></td>
  <td><img name="copyright_bar" src="images/copyright_bar.gif" width="272" height="20" border="0" alt="Copyright 2006 Newland Tours." /></td>
 </tr>
 <tr>
  <td colspan="2">	
	<h1><br />
	  <a name="top" id="top"></a><img src="<?php echo $row_rs_countries['imageURL']; ?>" align="right" />Opis kraju</h1>
    <h2><?php echo $row_rs_countries['countryName']; ?></h2>
    <p><strong>Rejon &#347;wiata:</strong><br />
      <?php echo $row_rs_countries['regionName']; ?></p>
    <p><strong>Opis:</strong><br />
      <?php echo $row_rs_countries['description']; ?></p>
    <p><strong>Na zdj&#281;ciu:</strong><br />
      <?php echo $row_rs_countries['imageALT']; ?></p>
    <p><strong>Liczba ludno&#347;ci:</strong><br />
      <?php echo number_format($row_rs_countries['population'],0,'.', " "); ?>
    <p><strong>Waluta:</strong><br />
      <?php echo $row_rs_countries['country_currency']; ?></p>
    <p>&nbsp;</p></td>
 </tr>
</table>

<br />


<map name="navbarMap" id="navbarMap">
 <area shape="rect" coords="1,0,62,20" href="index.php" alt="Home" />
 <area shape="rect" coords="71,0,117,20" href="about.php" alt="About" />
 <area shape="rect" coords="129,0,196,20" href="tours.php" alt="Find Tours" />
 <area shape="rect" coords="209,0,311,20" href="profiles.php" alt="Country Profiles" />
 <area shape="rect" coords="327,0,434,20" href="contact.php" alt="Contact An Agent" />
</map>
</body>
</html>
<?php
mysql_free_result($rs_countries);
?>