Map
Groups
Profile
Hike On!
Thhe ultimate hiking guide for USC students
Difficulty
Distance from USC
Length
Duration
Search
All Hikes
// re: this, i can't fix until we're able to load php cards connect_error) { die("Connection failed: " . $mysql->connect_error); } $sql = "SELECT * FROM mainView"; $result = $mysql->query($sql); if ($result->num_rows > 0) { // output data of each row while($currentrow = $result->fetch_assoc()) { $difficulty = "wow"; if($currentrow["difficulty"] == "Easy"){ $difficulty = "easyTag"; } else if($currentrow["difficulty"] == "Moderate"){ $difficulty = "mediumTag"; } else if($currentrow["difficulty"] == "Hard"){ $difficulty = "hardTag"; } echo '
' . $currentrow["lattitude"] . ' N, ' . $currentrow["longitude"] . ' W' . '
' . $currentrow["name"] . '
' . $currentrow["length"] . ' miles
' . $currentrow["duration"] . ' hr
' . $currentrow["difficulty"] . '
'; } } else { echo "0 results"; } $mysql->close(); ?>
