Museum Details |
| |
include("dbinfo.inc.php");
##include database info and connect to database
$db=mysql_connect(localhost,$username,$password);
@mysql_select_db($database,$db) or die( "Unable to select database");
mysql_set_charset('utf8', $db);
##if search word does not exist retrieve it from search page else use the one passed in URL
if(!$_GET['id']) {
$Mid=$HTTP_POST_VARS['id'];
} else {
$Mid=$_GET['id'];}
if(!$_GET['name']) {
$name=$HTTP_POST_VARS['name'];
} else {
$name=$_GET['name'];}
if(!$_GET['city']) {
$city=$HTTP_POST_VARS['city'];
} else {
$city=$_GET['city'];}
if(!$_GET['state']) {
$state=$HTTP_POST_VARS['state'];
} else {
$state=$_GET['state'];}
if(!$_GET['country']) {
$country=$HTTP_POST_VARS['country'];
} else {
$country=$_GET['country'];}
if(!$_GET['focus']) {
$focus=$HTTP_POST_VARS['focus'];
} else {
$focus=$_GET['focus'];}
$result = mysql_query("select * from museum_list WHERE museum_list_id = '$Mid'");
$result_cnt = mysql_num_rows($result);
for ($i=0; $i<$result_cnt; $i++) {
$row = mysql_fetch_array($result);
echo 'Name: | ';
echo ''.$row['name'] . ' |
';
echo 'Street Address: | ';
echo ''.$row['streetaddress'].' |
';
echo 'City: | ';
echo ''.$row['city'].' |
';
echo 'State: | ';
echo ''.$row['state'].' |
';
echo 'Country: | ';
echo ''.$row['country'].' |
';
echo 'Zipcode: | ';
echo ''.$row['zipcode'].' |
';
echo 'Telephone: | ';
echo ''.$row['telephone'].' |
';
echo 'Fax: | ';
echo ''.$row['fax'].' |
';
echo 'Email: | ';
echo ''.$row['email'].' |
';
echo 'Website: | ';
echo ''.$row['website'].' |
';
echo 'Staff Contacts: | ';
echo ''.$row['staffcontacts'].' |
';
echo 'Quality of Online Info: | ';
echo ''.$row['qualityofonlineinfo'].' |
';
echo 'Size: | ';
echo ''.$row['size'].' |
';
echo 'Focus: | ';
echo ''.$row['focus'].' |
';
echo 'Source: | ';
echo ''.$row['source'].' |
';
echo '
';
echo '