<? 
$path = preg_split ("/[\/]+/", $PHP_SELF);
$filename2 = $path[count($path) -1];
$filename2 = ereg_replace("_impressions" , "",$filename2);

include "db.php";

if (!mysql_connect ($host, $usr, $pwd)) {echo "WARNING! Data Base connection error."; exit;}
mysql_select_db($db_name);

$result = mysql_query("SELECT * FROM greece_travel WHERE filename = '$filename2'");
while ($row = mysql_fetch_array($result)) {
	$title = $row[2];
	$keywords = $row[3];
	$hotelname = $row[4];
	$starRating = $row[5];
	$description = $row[6];
	$mainPhoto  = $row[7];
	$photos = $row[8];
	$city = $row[9];
	$address = $row[10];
	$dphoto = $row[11];
	$price = $row[12];
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<Meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<Meta name="keywords" content="<? echo strtolower($keywords); ?>, <? echo strtolower($city); ?>, greece, athens, hotels, accommodation, lodging, discount, holiday">
<Meta name="description" content="<? echo $title; ?>. Greece hotels on-line directory.">
<title><? echo $title; if (!empty($city)) {echo ", ". $city; } ?> 35% DISCOUNT</title>
<? include "header.php"; ?>

            <table class="text">
              <tr>
                <td>
 <?
include "db.php";

if (!mysql_connect ($host, $usr, $pwd)) {echo "WARNING! Data Base connection error."; exit;}
mysql_select_db($db_name);

	echo "<br><b><font color=\"#336699\">$hotelname Impressions</font></b></br>";
    $impr_result = mysql_query("SELECT * FROM greece_impr WHERE (hotel = '$hotelname')");
    while ($row = mysql_fetch_array($impr_result)) {
	$id = $row[0];
	$mr = $row[1];
	$name = $row[2];
	$surname = $row[3];
	$email = $row[4];
	$hotel = $row[5];
	$board  = $row[6];
	$month = $row[7];
	$year = $row[8];
	$rating = $row[9];
	$impr = $row[10];
	$date = $row[11];

    	echo "<br><b>$date</b></br>";
    	echo "<i>Review by:</i> $mr $name $surname</br>";
    	echo "<i>Hotel:</i> <font color=\"#336699\">$hotel</font><br>";
    	echo "<i>Date of holiday:</i> $month/$year<br>";
    	echo "<i>Board:</i> $board<br>";
    	echo "<i>Rating:</i> <font color=\"Red\">$rating</font> / 10<br>";
    	echo "<i>Impressions:</i> $impr<br>";
    	echo "<hr size=\"2\" color=\"#336699\"><br>";
	}
    mysql_close();
    ?> 








<!-- Impressions end -->
<p align="left">
<? echo "<br><br><br><br><br><br><br><a href=\"../$filename2\" class=\"imprlinks\">Back to $hotelname</a>"; 
            ?>

</p>
      </td></tr>
      </table>
    </td>
    
      <? include "footer.php"; ?>
