session_start(); ?> if (isset($_SESSION['MM_MemberID'])) unset($_SESSION['MM_MemberID']); mysqli_select_db($database_Vacation, $Vacation); //$Query = sprintf("SELECT * FROM namethisplacecontests WHERE conteststartdate <= '" . date("Y-m-d") . "' and contestdate >= '" . date("Y-m-d") . "'"); $Query = sprintf("SELECT * FROM namethisplacecontests"); $Contest = mysqli_query( $Vacation, $Query) or die(mysqli_error()); $row_Contest = mysqli_fetch_assoc($Contest); $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if (isset($_POST["MM_update"]) && $_POST["MM_update"] == "form1") { unset($errormsg); if (strlen($_POST["guesscountry"]) < 2) $errormsg[] = "Please fill in your guess for the country."; if (strlen($_POST["guessplace"]) < 2) $errormsg[] = "Please fill in your guess for the place."; if (strlen($_POST["firstname"]) < 2) $errormsg[] = "Please fill in your first name."; if (strlen($_POST["lastname"]) < 2) $errormsg[] = "Please fill in your last name."; if (strlen($_POST["email"]) < 8) $errormsg[] = "Please fill in your email address."; if (strlen($_POST["address"]) < 5 || strlen($_POST["city"]) < 4 || strlen($_POST["state"]) < 2 || strlen($_POST["zip"]) < 5 || strlen($_POST["country"]) < 2 || (strlen($_POST["dayphone"]) < 6 && strlen($_POST["eveningphone"]) < 5)) $errormsg[] = "Please fill in your complete address and at least one phone number."; // if (isset($errormsg)) { // $_POST["MM_insert"] = ""; // unset($_POST["MM_insert"]); // } if (!isset($errormsg)) { mysqli_select_db($database_Vacation, $Vacation); if (isset($_POST["emailanswer"])) { $emailanswer = "Y"; $eclub="Contest Winner Information"; $insertQ=sprintf("INSERT INTO eclubcat (eclub_cat, firstname, lastname, email, address, city, `state`, zip, country, dayphone, eveningphone) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($eclub, "text"), GetSQLValueString($_POST['firstname'], "text"), GetSQLValueString($_POST['lastname'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['address'], "text"), GetSQLValueString($_POST['city'], "text"), GetSQLValueString($_POST['state'], "text"), GetSQLValueString($_POST['zip'], "text"), GetSQLValueString($_POST['country'], "text"), GetSQLValueString($_POST['dayphone'], "text"), GetSQLValueString($_POST['eveningphone'], "text")); mysqli_select_db($database_Vacation, $Vacation); $ResultQ = mysqli_query( $Vacation, $insertQ) or die(mysqli_error()); } else $emailanswer = "N"; if (isset($_POST["newsletter"])) { $newsletter = "Y"; $eclub="Newsletter Recipients"; $insertQ=sprintf("INSERT INTO eclubcat (eclub_cat, firstname, lastname, email, address, city, `state`, zip, country, dayphone, eveningphone) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($eclub, "text"), GetSQLValueString($_POST['firstname'], "text"), GetSQLValueString($_POST['lastname'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['address'], "text"), GetSQLValueString($_POST['city'], "text"), GetSQLValueString($_POST['state'], "text"), GetSQLValueString($_POST['zip'], "text"), GetSQLValueString($_POST['country'], "text"), GetSQLValueString($_POST['dayphone'], "text"), GetSQLValueString($_POST['eveningphone'], "text")); mysqli_select_db($database_Vacation, $Vacation); $ResultQ = mysqli_query( $Vacation, $insertQ) or die(mysqli_error()); } else $newsletter = "N"; $insertSQL = sprintf("INSERT INTO namethisplace (namethisplacecode, datecreated, status, guesscountry, guessplace, firstname, lastname, email, address, city, state, zip, country, dayphone, eveningphone, emailanswer, newsletter) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['namethisplacecode'], "text"), GetSQLValueString($_POST['datecreated'], "date"), GetSQLValueString($_POST['status'], "text"), GetSQLValueString($_POST['guesscountry'], "text"), GetSQLValueString($_POST['guessplace'], "text"), GetSQLValueString($_POST['firstname'], "text"), GetSQLValueString($_POST['lastname'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['address'], "text"), GetSQLValueString($_POST['city'], "text"), GetSQLValueString($_POST['state'], "text"), GetSQLValueString($_POST['zip'], "text"), GetSQLValueString($_POST['country'], "text"), GetSQLValueString($_POST['dayphone'], "text"), GetSQLValueString($_POST['eveningphone'], "text"), GetSQLValueString($emailanswer, "text"), GetSQLValueString($newsletter, "text")); mysqli_select_db($database_Vacation, $Vacation); $Result1 = mysqli_query( $Vacation, $insertSQL) or die(mysqli_error()); $_POST['namethisplaceid'] = mysqli_insert_id(); $GLOBALS['namethisplaceid'] = mysqli_insert_id(); session_register('namethisplaceid'); $Thankyou = "
Thank you for your entry in the Top Choice Vacation Rentals "Name This Place" Contest! If your contest entry includes a correct entry for the place in the photo, it will be entered, along with other correct entries, in the drawing for this month's winnner.
"; $Thankyou .= "We have a contest each month with a new "Name This Place" photo. We invite you to enter the new contest each month. All correct entry forms will be entered in the drawing for each month's winner. Correct entries for each month will automatically be entered in our End-of-the-Year Grand Prize Drawing."; $Thankyou .= "Good Luck!
Thank You, for visiting our website!
"; $Thankyou .= "Top Choice Vacation Rentals Website
Contest Management Team
"NAME THIS PLACE" CONTESTif (isset($errormsg)){ echo "";
foreach($errormsg as $msg){
echo "$msg
Enter to Win | Contest Rules | Prizes | Provide a Contest Photo " TARGET="_blank">
" WIDTH="400" HEIGHT="300" BORDER="1" ALT="Name This Place"> echo $row_Contest["headline"]; ?> Please note that all entries with correct answers to the monthly "Name This Place" Contest will be automatically entered into our End Of Year Grand Prize Drawing for a an additional chance to win! Welcome to Top Choice Vacation Rentals Contest Rules!
This month's prize for the Name This Place Contest is: echo $row_Contest["prizedescription"]; ?> "
TARGET="_blank">" WIDTH="137"
HEIGHT="216" BORDER="0">
Top Choice Vacation Rentals invites members and viewers of the website to provide us with interesting "place" photos for our Monthly "Name This Place" Contest. The photo can be of a "place" worldwide. The photo must be unique enough so that it could only be one recognizable location, but would be a fun challenge for viewers to recognize. Along with the photo, please email us the name of the country where the "place" is located, the state or province, and the city or nearest city and specific location. Please provide a brief description of the place. You can give historical info, geographical info, or other info about the "place", some of which we may include as clues to the photo. This is a great opportunity for Property Owners to submit photos for greater exposure of their geographical area and to help to create additional tourism in their area, as well as to attract more travelers to their vacation rental businesses. Photos from Chambers of Commerce or Tourist Bureaus are welcome. Viewers and Travelers are also encouraged to join the fun and submit their favorite "place" photos from their worldwide travels! Please email your "place" photo along with the associated information to contestphotos@topchoicevacationrentals.com. By submitting your photo(s) and information your are certifying that you have the legal right to or ownership of the photo, and you are granting Top Choice Vacation Rentals permission and indemnity to use the photo(s) and related information in our Name This Place Contest, and you are granting Top Choice Vacation Rentals all legal rights to the photos and information. |
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