"; ?> dbHSCS_case.php

Back to Database Selection Page

DESTINATIONS DATABASE

".$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

"; } echo "
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 "
"; //close mysql connection mysqli_close($con); ?>

Back to top