$dbhost='db2.modwest.com'; //$dbhost='localhost'; $dbusername='snowbowl'; //$dbusername='root'; $dbuserpass='11seeker'; //$dbuserpass=''; $dbname='montanasnowbowl'; mysql_connect($dbhost, $dbusername, $dbuserpass); mysql_select_db("$dbname"); $sbase = "SELECT * FROM basesummit "; $sbase .= "WHERE baseorsummit = 'base' "; $result_base = mysql_query("$sbase"); $row_base = mysql_fetch_array($result_base); $base_depth = $row_base["depth"]; $base_new_snow = $row_base["newSnow"]; $base_temp = $row_base["temp"]; $base_wind = $row_base["wind"]; $rsummit = "SELECT * FROM basesummit "; $rsummit .= "WHERE baseorsummit = 'summit' "; $result_summit = mysql_query("$rsummit"); $row_summit = mysql_fetch_array($result_summit); $summit_depth = $row_summit["depth"]; $summit_new_snow = $row_summit["newSnow"]; $summit_temp = $row_summit["temp"]; $summit_wind = $row_summit["wind"]; $result_report = mysql_query("SELECT * FROM skireport"); $row_report = mysql_fetch_array($result_report); $forecast = $row_report["forecast"]; $tomorrowforecast = $row_report["tomorrowforecast"]; $powder = $row_report["powder"]; $powderpacked = $row_report["powderpacked"]; $packed = $row_report["packed"]; $groomed = $row_report["groomed"]; $firmpacked = $row_report["firmpacked"]; $springsnow = $row_report["springsnow"]; $open = $row_report["open"]; $roadconditions = $row_report["roadconditions"]; $specialmessages = $row_report["specialmessages"]; $snow1 = $row_report["snow1"]; $snow2 = $row_report["snow2"]; $snow3 = $row_report["snow3"]; $snow4 = $row_report["snow4"]; $snow5 = $row_report["snow5"]; $snow6 = $row_report["snow6"]; $snow7 = $row_report["snow7"]; $date = $row_report["updated"]; $n_hours = $row_report["n_hours"]; $n_lifts = $row_report["n_lifts"]; $n_runs = $row_report["n_runs"]; $n_surfaceconditions = $row_report["n_surfaceconditions"]; $n_windspeed = $row_report["n_windspeed"]; ?>
Click here for the photo for the day Updated: $date“;?>
Snow Conditions
$icon = "“;
Today’s Forecast:
Tomorrow’s Forecast: Snowbowl is
Road Conditions: echo "$roadconditions “;?> echo "$specialmessages"; ?>
Previous Days’ Snowfall
|