".$mtnArea.'';
}
$mtnArea='';
}
else { //echo "we have no mtn region";
//Query database for mtnArea(s) to put in dropdown based on radio button section of $mtnRegion
$query = "SELECT DISTINCT mtnArea FROM details ORDER by mtnArea";
$result = mysqli_query($con, $query) or die("Error: ".mysqli_error($con));
while ($row=mysqli_fetch_array($result)) {
$mtnArea=$row["mtnArea"];
$options.="';
}
$mtnArea='';
}
//Query database for tripType(s) to but in dropdown
$query2 = "SELECT DISTINCT tripType FROM details WHERE 1" ;
$result2 = mysqli_query($con, $query2) or die("Error: ".mysqli_error($con));;
while ($row=mysqli_fetch_array($result2)) {
$tripType=$row["tripType"];
$options2.="';
}
?>
You didn't select any Mountain Area!\n");
}
}
if(isset($_POST['formSubmit']))
{
$tripType = ($_POST['tripType']);
if(!isset($tripType))
{
echo("
You didn't select any Trip Type!
\n");
}
}
?>
Click 'Area' for Google earth view Click 'Destination/Route' for pictures/videos
ID
Area
Destination/Route
Trip Type
Length
St/Prov
";
echo $row['rtid']; $rtid=$row['rtid'];
echo "
";
echo $row['mtnArea'];
echo "
";
echo $row['route'];
echo "
";
echo $row['tripType'];
echo "
";
echo $row['length'];
echo "
";
echo $row['st/prov'];
echo "
";
}
echo "
";
//close mysql connection
mysqli_close($con);
?>