 |
| include "includes/leftnav.php"; ?> |
|
|

include "includes/db_link.php";
$myDbLink = new db_link();
$table="events";
?>
|
$today = date('Ymdhis');
//echo $today;
$rowb = 0;
$rowr = 0;
$rowx = 0;
$sql = "SELECT id, event_name, event_date, event_details, event_type, link from events WHERE event_date > '$today' ORDER BY event_type";
$results = mysql_query ($sql,$myDbLink->db_link);
while ($row = mysql_fetch_object ($results)) {
$start_date = $row->event_date;
$start_date = substr($start_date, 0, 10);
$start_date = explode("-", $start_date);
$year = $start_date[0];
$month = $start_date[1];
$day = $start_date[2];
$image = $row->event_type;
if ($image == 'Ski Bash') {
if (($rowb =='0') && ($event_type = 'Ski Bash')) {
echo " ";
$rowb++; }
}
if ($image == 'Redemption') {
if ($rowr =='0' && ($event_type = 'Redemption')) {
echo " ";
$rowr++; }
}
if ($image == 'Mountain') {
if ($rowx =='0' && ($event_type = 'Mountain')) {
echo "Our Mountain Events ";
$rowx++; }
}
echo " ";
}
//mysql_close($connection);
?>
//echo $GuideCategory;
mysql_free_result($results);
?>
|
include "includes/copyright.php"; ?>
|
|