Haunted House




Haunted Houses in the Western USA and Canada

"; //echo "
Displaying results Eastern | Central | Western | Canada
"; if($GetAllHHWCOUNT <=0) { echo "No Haunted Houses found..."; } else { while ($row = mysql_fetch_array($GetAllHHWResult, MYSQL_BOTH)) { $StateProvince = $row["StateProvince"]; echo "

$StateProvince -

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

$City -

"; $GetAllHHWCityDetails = "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"; $GetAllHHWCityDetailsResult = mysql_query($GetAllHHWCityDetails) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHWCityDetailsResult, 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($GetAllHHWCityDetailsResult, MYSQL_BOTH)) echo "
"; } //end of while ($row = mysql_fetch_array($GetAllHHWCityResult, MYSQL_BOTH)) } //end of while ($row = mysql_fetch_array($GetAllHHResult, MYSQL_BOTH)) } //end of else /////************************Canada*****************************************///// $GetAllHHW = "SELECT distinct(StateProvince) FROM FX_HauntedHouses WHERE TimeZoneLocation = 'Western' AND Display = 'Y' AND Country = 'Canada' ORDER BY StateProvince ASC, City ASC, NameOfAttraction ASC"; $GetAllHHWResult = mysql_query($GetAllHHW) or die ("Couldn't execute query because: " . mysql_error()); $GetAllHHWCOUNT = mysql_num_rows($GetAllHHWResult); //ECHO "COUNT: $GetAllHHWOUNT
"; //echo "
Displaying results Eastern | Central | Western | Canada
"; if($GetAllHHWCOUNT <=0) { echo "No Haunted Houses found..."; } else { while ($row = mysql_fetch_array($GetAllHHWResult, MYSQL_BOTH)) { $StateProvince = $row["StateProvince"]; echo "

$StateProvince -

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

$City -

"; $GetAllHHWCityDetails = "SELECT *, DATE_FORMAT(DatePosted, '%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"; $GetAllHHWCityDetailsResult = mysql_query($GetAllHHWCityDetails) or die ("Couldn't execute query because: " . mysql_error()); while ($row = mysql_fetch_array($GetAllHHWCityDetailsResult, MYSQL_BOTH)) { $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

"; } //end of while ($row = mysql_fetch_array($GetAllHHWCityDetailsResult, MYSQL_BOTH)) echo "
"; } //end of while ($row = mysql_fetch_array($GetAllHHWCityResult, 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: