'" . date("Y-m-d") . "' AND rentals.featuredexpires > '" . date("Y-m-d") . "' AND rentals.isfeatured = 'Y' AND "; $Fields = "SELECT DISTINCT rentals.rentalid, rentallocation, rentalcity, rentals.listingheadline, listing, "; $Fields .= "ratesfrom, daily1, daily2, daily3, daily4, states.statecode, states.statename, "; $Fields .= "rentals.primaryphotoid, rentals.featuredphotoid, photos.filename, "; $Fields .= "rentals.isfeatured, rentals.featuredexpires, featuredcityexpires, featuredstateexpires, featuredcountryexpires, featuredworldexpires "; $Tables = " FROM rentals LEFT JOIN states ON rentals.rentalstatecode = states.statecode "; $Tables .= " LEFT JOIN photos ON rentals.primaryphotoid = photos.photoid "; if ($Where != "") { $Where = " WHERE " . substr($Where, 0, strlen($Where)-5); } //echo $Where; $Query = $Fields . $Tables . $Where . " ORDER BY datecreated desc"; 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); $page_title = "Top Featured Vacation Rentals"; include('includes/topchoice-header.php'); ?>

TOP FEATURED VACATION RENTALS

"; } ?>


Printer-Friendly Page | Bookmark This Vacation Rental Site | Email This Page to a Friend 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