";
mysql_free_result($results1);
$sql = "SELECT * from skiwatch WHERE id LIKE '$id' ";
$results = mysql_query ($sql,$myDbLink->db_link);
while ($row = mysql_fetch_object ($results)) {
echo "$row->Mountain_Name
(Number $row->Map_Reference on the Map) |
";
echo "| $row->Address_1 | $row->Address_2 |
";
echo "| $row->Mountain_City | $row->State |
";
echo "| Snow Phone: $row->Snow_Phone | Web Site: Web_Site\" target=\"_blank\">$row->Web_Site |
";
echo "
|
";
echo "| Vertical Rise (Feet): $row->Vertical_Rise | Top Elevation: $row->Top_Elevation | Number of Trails: $row->Number_of_Trails | Skiable Acres: $row->Skiable_Acres |
";
echo "| Snowmaking (% covered): $row->Snowmaking | Lifts (Total): $row->Lifts | Difficulty (green/blue/black): $row->Difficulty_Green/$row->Difficulty_Blue/$row->Difficulty_Black |
";
echo "
";
echo "| Handicaped Programs: $row->Handicapped_Programs | Cross Country: $row->Cross_Country |
";
echo "| Kids Programs: $row->Kids_Programs | Recreational Racing: $row->Recreational_Racing |
";
echo "| Snowboarding: $row->Snowboarding | Lodging Within 10 Miles: $row->Lodging_10_Miles |
";
echo "| Night Skiing: $row->Night_skiiing | Child Care: $row->Child_Care |
";
echo "| Half Pipe(s) : $row->Half_Pipes | Terrain Park(s): $row->Terrain_Parks |
";
echo "| Tubing : $row->Tubing |
";
$sql = "SELECT state, report from ski_reports WHERE state LIKE '$row->State' ";
$results = mysql_query ($sql,$myDbLink->db_link);
while ($row = mysql_fetch_object ($results)) {
if ($row->report) {
echo "| $row->Mountain_Name Ski Report |
";
echo "| $row->report |
";
}
}
}
//mysql_close($connection);
?>
