Haunted Houses in the Central USA

*/ ?>

Haunted Houses in the Central USA:

"; //echo "

Displaying results Eastern | Central | Western | Canada

"; if($GetAllHHCCOUNT <=0) { echo "No Haunted Houses found..."; } else { while ($row = mysql_fetch_array($GetAllHHCResult, MYSQL_BOTH)) { $StateProvince = $row["StateProvince"]; echo "

$StateProvince -

"; $GetAllHHCCity = "SELECT distinct(City) FROM FX_HauntedHouses WHERE StateProvince = '$StateProvince' AND TimeZoneLocation = 'Central' AND Display = 'Y' ORDER BY City ASC"; $GetAllHHCCityResult = mysql_query($GetAllHHCCity) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHCCityResult, MYSQL_BOTH)) { $City = $row["City"]; echo"

$City -
"; $GetAllHHCCityDetails = "SELECT *, DATE_FORMAT(LastUpdate, '%Y-%m-%d') as DateFormatted FROM FX_HauntedHouses WHERE StateProvince = '$StateProvince' AND City = '$City' AND Display = 'Y' ORDER BY StateProvince ASC, City ASC, NameOfAttraction ASC"; $GetAllHHCCityDetailsResult = mysql_query($GetAllHHCCityDetails) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHCCityDetailsResult, MYSQL_BOTH)) { $PrimaryID = $row["PrimaryID"]; $NameOfAttraction = $row["NameOfAttraction"]; $Slogan = $row["Slogan"]; $Comments = $row["Comments"]; $URL = $row["URL"]; $Address = $row["Address"]; $City = $row["City"]; $StateProvince = $row["StateProvince"]; $Country = $row["Country"]; $SubmitterName = $row["SubmitterName"]; $SubmitterEmail = $row["SubmitterEmail"]; $SubmitterAddress = $row["SubmitterAddress"]; $SubmitterPhone = $row["SubmitterPhone"]; $SubmitterHouseSizeFeet = $row["SubmitterHouseSizeFeet"]; $SubmitterHouseSizeAcres = $row["SubmitterHouseSizeAcres"]; $FormOfContact = $row["FormOfContact"]; $DatePosted = $row["DatePosted"]; $DateFormatted = $row["DateFormatted"]; $LastUpdate = $row["LastUpdate"]; if($URL <> '' ) { $NameOfAttraction = "$NameOfAttraction"; } if($Address <> '' ) { $Address = "$Address
"; } if($Slogan <> '' ) { $Slogan = "$Slogan
"; } if($Comments <> '' ) { $Comments = "$Comments
"; } echo "

$NameOfAttraction
$Address $Slogan $Comments Posted: $DateFormatted FX ID: $PrimaryID

"; } //end of while ($row = mysql_fetch_array($GetAllHHCCityDetailsResult, MYSQL_BOTH)) echo "

"; } //end of while ($row = mysql_fetch_array($GetAllHHCCityResult, MYSQL_BOTH)) } //end of while ($row = mysql_fetch_array($GetAllHHResult, MYSQL_BOTH)) } //end of else ?>

This page originally posted: 09/29/2000
This page last updated: