The Capitol Reef Region offers a wide range of lodging options from Motels, Bed & Breakfasts, Cabins, and Campgrounds. Click on the town or the lodging type below to see available lodging.
500 Internal Server Error
Internal Server Error
Mismatch between target UID (33) and UID (6615) of file "/home/users/c/capreef/public_html/lodging.php"
suPHP 0.8.0-pre
";
echo"
By Community
";
$Cquery2 = "SELECT * FROM tbl_categorysub";
$Cresult2 = mysql_query($Cquery2);
$Ccount = 0;
while($Crow2 = mysql_fetch_array($Cresult2))
{
include("citformat.php");
echo"
";
$Catquery2 = "SELECT * FROM tbl_category WHERE categoryModuleID = '26' and categorySection = 'Lodging' ORDER BY categorySortOrder";
$Catresult2 = mysql_query($Catquery2);
$count2 = 0;
while($Catrow2 = mysql_fetch_array($Catresult2))
{
$query2 = "SELECT * FROM mdl_mrebusinesslist WHERE recordSubCatID = '$Crow2[ID]' and recordCategoryID = '$Catrow2[ID]' and recordShow = 1 ORDER BY recordSubCatID,recordName";
$result2 = mysql_query($query2);
$rowcount2 = mysql_num_rows($result2);
if($rowcount2 > 0)
{
//include("catformat.php");
echo"
$Catrow2[categoryName]
";
//echo"
";
while($row2 = mysql_fetch_array($result2))
{
include("queryformat2.php");
}
//echo"
";
}
$count2++;
}
echo"
";
$Ccount++;
}
echo"
";
echo"
";
echo"
By Lodging Type
";
$Catquery = "SELECT * FROM tbl_category WHERE categoryModuleID = '26' and categorySection = 'Lodging' ORDER BY categorySortOrder";
$Catresult = mysql_query($Catquery);
if($Catresult)
{
$count = 0;
while($Catrow = mysql_fetch_array($Catresult))
{
$query = "SELECT * FROM mdl_mrebusinesslist WHERE recordCategoryID = '$Catrow[ID]' and recordShow = 1 ORDER BY recordSubCatID,recordName";
$result = mysql_query($query);
$rowcount = mysql_num_rows($result);
if($result)
{
if($rowcount > 0)
{
include("catformat.php");
echo"
";
$Tracking = 0;
$Ccount = 0;
while($row = mysql_fetch_array($result))
{
$Cquery = "SELECT * FROM tbl_categorysub WHERE ID = '$row[recordSubCatID]'";
$Cresult = mysql_query($Cquery);
//$Rcount = mysql_num_rows($Cresult);
while($Crow = mysql_fetch_array($Cresult))
{
if($row[recordSubCatID] != $Tracking)
{
//if($Ccount > 0){echo"
";}
echo"
$Crow[subCatName]
";
//echo "
";
//echo"
";
$Tracking = $Crow[ID];
}
include("queryformat.php");
$Ccount++;
}
//include("queryformat.php");
//if($Ccount == $rowcount){echo"
";}
}
echo"
";
}
}
$count++;
}
}
echo"
";
?>
