if (!isset($_GET['month'])) $_GET['month'] = date("n"); if (!isset($_GET['year'])) $_GET['year'] = date("Y"); $monthStart = mktime(0,0,0,$_GET['month'],1,$_GET['year']); $monthEnd = mktime(0,0,0,$_GET['month'], date("t", $monthStart),$_GET['year']); //$Query = "Select events.eventid, eventdates.eventdateid, eventdates.date, eventname, eventcity, eventstatecode, states.statename "; //$Query .= "FROM events INNER JOIN eventdates ON events.eventid = eventdates.eventid "; $Query = "Select eventname, startdate, enddate, eventcity, eventstatecode, states.statename "; $Query .= "From events LEFT JOIN states ON events.eventstatecode = states.statecode "; $Query .= "WHERE "; if ((isset($_POST["date1"]) && $_POST["date1"] != "") || (isset($_POST["date2"]) && $_POST["date2"] != "")) { $theValue1 = ""; $theValue2 = ""; if ($_POST["date1"] != "") { $newdate1 = explode("/",trim($_POST["date1"])); $theValue1 = $newdate1[2] . "-" . $newdate1[0] . "-" . $newdate1[1]; } if ($_POST["date2"] != "") { $newdate2 = explode("/",trim($_POST["date2"])); $theValue2 = $newdate2[2] . "-" . $newdate2[0] . "-" . $newdate2[1]; } if ($theValue1 != "" && $theValue2 != "") $Query .= "enddate >= '" . $theValue1 . "' AND startdate <= '" . $theValue2 . "' "; else if ($theValue1 != "") $Query .= "enddate >= '" . $theValue1 . "' "; else $Query .= "startdate <= '" . $theValue2 . "' "; } else $Query .= "enddate >= '" . date("Y-m-d", $monthStart) . "' AND startdate <= '" . date("Y-m-d", $monthEnd) . "' "; if (isset($_POST["country"]) && $_POST["country"] != "") $Query .= " AND eventcountrycode = '" . $_POST["country"] . "' "; if (isset($_POST["state"]) && $_POST["state"] != "") $Query .= " AND eventstatecode = '" . $_POST["state"] . "' "; $Query .= " ORDER BY startdate"; //echo $Query; //exit(); mysqli_select_db($Vacation,$database_Vacation); $query_Recordset1 = sprintf($Query); $Recordset1 = mysqli_query( $Vacation,$query_Recordset1) or die(mysqli_error()); $row_Recordset1 = mysqli_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysqli_num_rows($Recordset1); if ($_GET['month'] == 1) { $prevmonth = 12; $prevyear = $_GET['year'] - 1; } else { $prevmonth = $_GET['month'] - 1; $prevyear = $_GET['year']; } if ($_GET['month'] == 12) { $nextmonth = 1; $nextyear = $_GET['year'] + 1; } else { $nextmonth = $_GET['month'] + 1; $nextyear = $_GET['year']; } $page_title = "Top Choice Event Calendar"; include('includes/topchoice-header.php'); ?>
EVENTS CALENDARWelcome to Top Choice Vacation Rentals Events Calendar! TRAVELERS: EVENT MANAGERS, CHAMBERS OF COMMERCE AND TOURIST
BUREAUS: Events Calendar Listings For $date = mktime(0,0,0,$_GET['month'],1,$_GET['year']); echo date("M, Y",$date); ?>
|
Printer-Friendly Page | Bookmark This Vacation Rental Site | if (isset($_GET['rentalid'])) { ?> " STYLE="font-size: 8 pt">Email This Page to a Friend } else { ?> " STYLE="font-size: 8 pt">Email This Page to a Friend } ?>
Home |
Vacation Rental FAQ's |
About Top Choice Vacation Rentals |
Contact Us |
Vacation Rental Press Room
TCVR Members Log In |
List Your Rental |
Properties For Sale |
Vacation Rentals Specials |
Featured Rentals
Calendar of Events |
Renters Testimonials |
Join Our Frequent User E-Club |
E Vacation Planner
New Vacation Rental Listings |
Link with Us |
Our Friends
Copyright © 2005 by Top Choice Vacation Rentals All Rights Reserved |
Copyright © 2005 by Top Choice Vacation Rentals All Rights Reserved | Privacy & Legal Statement | Site Map