<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

	<head>
	
		<title>Los Angeles Stadt der Engel</title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<link rel='stylesheet' media='all' type="text/css" href="stylesheet.css" />
		<style type="text/css"></style>

	</head>
	
	<body>
	
		<?php
			require_once("db_connection.php");
			require_once("poi.txt");
			echo "<div class='data'>\n";
			echo "<B><p class='menue'>Wie lautet die Adresse eines bestimmten Point of Interest?</p><br /></B>\n";

			if (array_key_exists ('pois',$_GET)) {
				$pois = $_GET['pois'];
				
				$query = "SELECT address FROM pois WHERE name = '".$pois."'";
				$result = mysql_query($query) OR die("ERROR! ".mysql_error());
				if (mysql_num_rows($result) > 0) {      
					while($row = mysql_fetch_array($result)){
					$adresse=$row['address'];
                
					echo "<br/><p>Die Adresse von <b>$pois</b> lautet: <b>$adresse</b> </p>";
					
					}
					
				}
				
				else { //Error
					
					echo "<h2>Warnung:</h2> <b>$pois</b> konnte nicht gefunden werden. Bitte achten Sie auf korrekte Schreibweise!<br/>";
					}
				} 
			
				else { 
					echo "<B><br/><p class='submenue'>Bitte Point of Interest eingeben!</p></B>";
					}   
					   
					echo "<form method='get' action=''>";
					echo "<input name='pois' type='text' size='30' maxlength='50'>";
					echo "<input type='submit' name='submit' value='Anzeigen'/>";
					echo "<input type='hidden' name='page' id='page' value='querys/query7'>";
					echo "<input type='hidden' name='nav' id='nav' value='subpages'>";
					echo"</form>"
			
		?>
		
	</body>
</html>