<?php

 require("../common/database.php");
 if ( ! $link ) {
   die( "Couldn't connect to MySQL: ".mysql_error() ); }


if (isset($_GET['domain']) && $_GET['domain'] != '') {
	//Add slashes to any quotes to avoid SQL problems.
	$domain = addslashes($_GET['domain']);
	//Get every page title for the site.
	$result = mysql_query("SELECT * FROM key_person WHERE Domain_Name='".$domain."'");
	while($kp = mysql_fetch_array($result)) {
		//Return each page title seperated by a newline.
		echo "<option value='".$kp['Id']."'>".$kp['Name']."\n";
	}
}
?>